解决方法: 下载sql 2005 驱动: http://www.microsoft.com/downloads/zh-cn/details.aspx?FamilyID=E22BC83B-32FF-4474-A44A-22B6AE2C4E17&displaylang=zh-cn
修改1:
Sql代码 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // 2005 version Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); // 2000 version Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // 2005 version Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); // 2000 version修改2:
Sql代码 Connection con = DriverManager.getConnection("jdbc:sqlserver://<ServerName>;user=<UserName>;password=<Password>");//2005 version Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://<ServerName>;user=<UserName>;password=<Password>");//2000 version Connection con = DriverManager.getConnection("jdbc:sqlserver://<ServerName>;user=<UserName>;password=<Password>");//2005 version Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://<ServerName>;user=<UserName>;password=<Password>");//2000 version如:
Sql代码 //SQL2005 version connection.driver_class=com.microsoft.sqlserver.jdbc.SQLServerDriver Connection.url=jdbc:sqlserver://localhost:1433;DatabaseName=Hello //SQL2005 version connection.driver_class=com.microsoft.sqlserver.jdbc.SQLServerDriver Connection.url=jdbc:sqlserver://localhost:1433;DatabaseName=Hello参考链接:http://support.microsoft.com/?scid=kb%3Ben-us%3B915834&x=15&y=16
