jdbc驱动已经装好,classpath 也设置好了
classpath = ,;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar
代码:
String CLASSNAME = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERANDDB = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jspdev";
String USERNAME = "sa";
String PWD = "sa";
try{
Class.forName(CLASSNAME);
con = DriverManager.getConnection(SERANDDB,USERNAME,PWD);
}
catch(Exception e)
{
e.printStackTrace();
}
运行报错:
D:\javawork>java TestConnection
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishin
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 TestConnection.DatabaseConnection(TestConnection.java:24)
at TestConnection.main(TestConnection.java:8)
classpath = ,;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar
代码:
String CLASSNAME = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERANDDB = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jspdev";
String USERNAME = "sa";
String PWD = "sa";
try{
Class.forName(CLASSNAME);
con = DriverManager.getConnection(SERANDDB,USERNAME,PWD);
}
catch(Exception e)
{
e.printStackTrace();
}
运行报错:
D:\javawork>java TestConnection
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishin
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 TestConnection.DatabaseConnection(TestConnection.java:24)
at TestConnection.main(TestConnection.java:8)
D:\javawork>java TestConnection
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
还有sql 2000 的sp3补丁也打了
建议先把这些证实了再说
比如:你的端口是不是打过补丁 变成了2433
是不是通过 127.0.0.1 访问一下试试@_@