sqlserver的jdbc driver

最新推荐文章于 2024-09-04 11:35:57 发布

sikaodeluwei

最新推荐文章于 2024-09-04 11:35:57 发布

阅读量1.2k

点赞数

分类专栏： sqlserver 文章标签： ms sql server

本文链接：https://blog.csdn.net/sikaodeluwei/article/details/24803287

版权

sqlserver 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

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