Welcome to MSDN Blogs Sign in | Join | Help

Microsoft JDBC Driver Team Blog

Discussions related to Microsoft JDBC driver.
Does SQL Server 2000 JDBC driver support SQL Server 2005?

We have heard from a number of customers asking if the SQL Server 2000 JDBC driver will work with SQL Server 2005.  Unfortunately, it will not.

If you are looking to migrate an existing SQL Server 2000 JDBC application running on the SQL Server 2000 JDBC driver to SQL Server 2005, we recommend that you download the latest SQL Server 2005 JDBC driver at http://msdn.microsoft.com/data/jdbc and update the existing JDBC application to work with the SS2005 JDBC driver.  Once that is working, upgrade the backend SQL Server 2000 to SQL Server 2005.  The SQL Server 2005 JDBC driver will work against SQL Server 2000, 2005, as well as the upcoming SQL Server 2008.

Jimmy Wu
SQL Server JDBC Team

Posted: Tuesday, June 03, 2008 5:35 PM by dpblogs
Filed under:

Comments

CGB said:

Nope you need sqljdbc.jar SQL200 use mssqlserver.jar

# June 5, 2008 1:45 AM

thst said:

What if this is not an option. We have some code licensed and it has class-names compiled in.

Recompiling something brings enormous testing effort and this requires time. In the meantime, customers require sql2000 to continue running.

Isn't there ANY way to change that beast? And why did you changed name and format of the driver class and URL :-/ (twice by the way, the new general JDBC driver has this changed again - so migration is actually not as easy as swapping files...)

# June 12, 2009 5:49 AM

dpblogs said:

Hello thst,

We will not be modifying our SQL Server 2000 driver. We recommend you move to a later driver, though we do understand that moving can be considerbly painful. We understand that some customers require SQL Server 2000 and continue to support SQL Server 2000 with all released versions of our driver. You should feel comfortable using the JDBC Driver 2.0 driver with SQL Server 2000.

--Tres London [SQL Server]

# July 6, 2009 8:42 PM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker