异常如下: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis hing 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.
(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:523) at java.sql.DriverManager.getConnection(DriverManager.java:171) at DbTest.init(DbTest.java:32) at DbTest.
(DbTest.java:25) at DbTest.main(DbTest.java:46) Press any key to continue... 经过google查询,原来出现上边错误的主要原因是默认的数据库服务器端口 1433没有打开,无法直接连接 ; 如果sqlser服务器没有升级到sp3(在使用jdbc时,如果系统是xp或者2003务必要把sqlserver 升级到sp3)就会出现上面的问题,我使用的正好是w2003+ mssql2000,没有做sqlsp3的升级 参考:http://java.chinaitlab.com/advance/34790.html
jdbc 连接SQL 2000数据库的问题
最新推荐文章于 2024-10-08 11:49:18 发布