MS JDBC for SQL 2005 released


In the spirit of sharing the love, Microsoft has announced the availability of the SQL Server 2005 JDBC Driver.   Now all the Java devs can get the goodness of SQL 2005.


For those of you familiar with the prior incarnation of the JDBC driver, this new release represents a very large internal Microsoft engineering effort.  Again it is a type-4 driver, which means no native code, it will install as a jar file.  It enables Java applications (including J2EE apps) on any platform to connect to SQL Server 2000 or 2005.  It is fully compliant with all the tests we could find to run against it (which was tricky).  This new version includes improvements in compliance, performance, and function, as well as support for SQL Server 2005 features such as XML. 


It’s a free download.  The license says it may be deployed in production by all SQL Server 2000 and SQL Server 2005 users, on any platform, at no additional charge.  It is supported by Microsoft directly.   Requires a 1.4 JVM. 


Microsoft is working with IBM to certify this driver with WebSphere, with BEA for WebLogic, and etc.  Contact me using the button above to suggest other java-based app servers to certify with.


www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx



Update (1055am US Eastern time, 20 Jan 2006):  Here’s the download page and a news article from eweek.

Update (110pm US Eastern time, 24 Jan 2006):  Here’s the real link to the SQL Server 2005 JDBC driver

Comments (3)

  1. MSDN Archive says:

    The correct link is http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx The driver works with SQL Express making it an interesting DB back-end for JSP apps

  2. Peter Hornby says:

    I’m a little confused. The link points to a page titled "SQL Server 2005 JDBC Driver Beta 2 Now Available", dated July 7, 2005. Can you clarify a little just what is being made available now? Is this v 1.0 or v1.1 of the driver, and is the statement on the linked page about "integrated authentication support" accurate?

    Thanks,

  3. Dino says:

    About links: The original link I posted is for the beta 2 release. In the update from 20 January I gave you the download to the new bits. Today I made another updated the post again, adding the link to the RTM version of the SQL 2005 JDBC driver.

    About integrated authentication: no. The team hoped to include that feature, but it did not make it into the v1.0 release.