请帮下忙:驱动能够正常加载
这是出错代码:
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket. 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:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at PublicClass.GetConnection.getConnection(GetConnection.java:27) at PublicClass.GetConnection.main(GetConnection.java:44)
这是出错代码:
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket. 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:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at PublicClass.GetConnection.getConnection(GetConnection.java:27) at PublicClass.GetConnection.main(GetConnection.java:44)
建议检查SQL Server 2000的配置,比如
1.是否升级打了补丁?请安装SP3。
2.SQL Server 2000的验证模式是不是用户名验证。
3.连接端口是否正常。
4.请关闭防火墙。或许你应该把关键代码贴过来!
驱动下载sp3的
用 纯驱动 是否打 sp4补丁了
JDBC-ODBC桥驱动程序:sun.jdbc.odbc.JdbcOdbcDriver
连接字符串:jdbc:odbc:mytest(mytest为dsn名称)
纯驱动 Sqlserver(三个jar包驱动程序)驱动程序:com.microsoft.jdbc.sqlserver.SQLServerDriver
连接字符串:jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testlocalhost为服务器名称或者IP地址,1433为SqlServer的端口号码,test为要访问的数据库名称