May I use the JDBC driver of SQLServer2000 to access SQLServer2005?

May I use the JDBC driver of SQLServer2000 to access SQLServer2005?Use SQL 2005 related JDBC driver http://msdn.microsoft.com/data/jdbc/ for such connecitons.|||

The JDBC 2000 driver can only be used to connect to SQL Server 2000. However, the JDBC 2005 driver can make connections to both SQL Server 2000 and 2005. Satya posted the link to the 2005 driver in the prior post. Here it is again: http://www.microsoft.com/downloads/details.aspx?FamilyId=6D483869-816A-44CB-9787-A866235EFC7C&displaylang=en

Thanks,

Jaaved Mohammed

sql

may i plz know about to transfer excel data to SqlServer2000

may i plz know about to transfer excel data to SqlServer2000Have a look at "DTS Import/Export Wizard" in SQL Books online

Maximum length for nvarchar in SQL2000

Hi,

I am using SQLSERVER2000.

When storing data in to database ,it is taking/storing only 255 characters for all the datatypes like nvarchar,nchar,char,ntext,text, etc...

I need to increase the maximum length of a field which takes 1000 characters & more.

I already increased the field length to 2000, but it is taking/storing only 255 characters.

Please help me in this............

It sounds like the parameters in your data access code are set to 255. Try checking them.

|||

I put 2000 characters for the parameter in the access code also.

|||

Why don't you post the client-side code you are using? Somewhere the data is being truncated, we just have to find out where.

Don