sqlserver的jdbc driver

sqlserver的jdbc让人很揪心啊。彻底的查了下资料，整理如下：

SQL Server 2000 Driver for JDBC Service Pack 3

Supported Operating System

Linux, WindowsXP

N/A

download url: http://www.microsoft.com/en-us/download/details.aspx?id=4252

PS:

sqlserver2000下载下来是个readme.txt。大体的意思是以前的jdbc driver （以前的sqlserver2000有3个驱动包：msbase,mssqlserver,msutil）已经不用了，给了个新的下载连接（ 下载下来就是Microsoft SQL Server JDBC Driver 3.0）。另外，driverName和url的写法也统一了，不在是以前的
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=sample";

它和所有其他的（2005,2008...）都一样了,都是下边的写法：

String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample";

Microsoft SQL Server JDBC Driver 2.0

Supported Operating System

Linux, Unix,Windows Server 2003 Service Pack 2, Windows Server 2008, Windows Vista ServicePack 1, Windows XP Service Pack 3

·        The list above is an example ofsome of the supported operating systems. The JDBC driver is designed to work onany operating system that supports the use of a Java Virtual Machine (JVM).However, only Sun Solaris, SUSE Linux, and Windows XP or later operatingsystems have been tested.

·        Java Development Kit: 5.0 or 6.0

 

·        SQL Server 2008 or SQL Server2005 or SQL Server 2000

download url:http://www.microsoft.com/en-us/download/details.aspx?id=2505

 

Microsoft SQL Server JDBC Driver 3.0

Supported Operating System

Linux, Unix,Windows 7, Windows Server 2003, Windows Server 2008 R2, Windows Vista, WindowsXP

·        The list above is an example ofsome of the supported operating systems. The JDBC driver is designed to work onany operating system that supports the use of a Java Virtual Machine (JVM).However, only Sun Solaris, SUSE Linux, and Windows XP or later operatingsystems have been tested.

·        Java Development Kit: 5.0 or 6.0

·        SQL Server 2008 R2 or SQL Server2008 or SQL Server 2005 or SQL Server 2000

download url:http://www.microsoft.com/en-us/download/details.aspx?id=21599

Microsoft JDBC Driver 4.0 for SQL Server

Supported Operating System

Linux, Unix,Windows 7, Windows Server 2008 R2, Windows Server 2012, Windows Vista

·        The list above is an example ofsome of the supported operating systems. The JDBC driver is designed to work onany operating system that supports the use of a Java Virtual Machine (JVM).However, only Sun Solaris, SUSE Linux, and Windows operating systems have beentested.

·        Java Development Kit: 5.0 and6.0

Supported SQL Server Versions:

·        Microsoft® SQL Server® 2012

·        Microsoft® SQL Server® 2008 R2

·        Microsoft® SQL Server® 2008

·        Microsoft® SQL Server® 2005

·        Microsoft® SQL Azure

download url:http://www.microsoft.com/en-us/download/details.aspx?id=11774