数据库驱动程序注册成功!java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source) at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source) at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source) at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at sqlconn.main(sqlconn.java:11)数据库连接失败Press any key to continue... 源代码是网上流传的一段测试代码 import java.sql.*;public class sqlconn{public static void main(String args[]) {try{Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();System.out.println("数据库驱动程序注册成功!");String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=northwind"; Connection conn = DriverManager.getConnection(url, "sa", "");System.out.println("数据库连接成功");}catch(Exception e){e.printStackTrace();System.out.println("数据库连接失败");} }}我已经打了sp3补丁,也安装了驱动
看下端口是否打开啦,我的也是1433端口打不开,才报这样的错误。估计是补丁跟sql版本不匹配吧!但是我也没有找到与之匹配的版本。
郁闷!