Sql Server 2000 的JDBC驱动程序连不上
我在机器上装了Microsoft SQL Server 2000 Driver for JDBC,然后在JBuilder X中加入了此类库(即msbase.jar;mssqlserver.jar ;msutil.jar)并在Enterprise Setup的Database Driver里加入了这个驱动。然后用一个例子测试,结果却连不上。
import java.sql.*;
public class DBTest {
public DBTest() {
String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs";
String user = "sa";
String password = "sa";
// Load the driver
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//connecting the database
Connection con = DriverManager.getConnection(dbUrl, user, password);
con.close();
}catch(Exception e)
{
System.out.println(e.getMessage());
}
}
public static void main(String[] args) {
DBTest DBTest1 = new DBTest();
}
}
运行后在Connection con = DriverManager.getConnection这句发生异常。
D:\bea\jdk141_03\bin\javaw -classpath "F:\随书盘\JBuilder9集成开发实例解析\JB9Codes\SqlServer\DB1\classes;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;D:\bea\jdk141_03\jre\lib\charsets.jar;D:\bea\jdk141_03\jre\lib\ext\dnsns.jar;D:\bea\jdk141_03\jre\lib\ext\ldapsec.jar;D:\bea\jdk141_03\jre\lib\ext\localedata.jar;D:\bea\jdk141_03\jre\lib\ext\sunjce_provider.jar;D:\bea\jdk141_03\jre\lib\im\indicim.jar;D:\bea\jdk141_03\jre\lib\jaws.jar;D:\bea\jdk141_03\jre\lib\jce.jar;D:\bea\jdk141_03\jre\lib\jsse.jar;D:\bea\jdk141_03\jre\lib\rt.jar;D:\bea\jdk141_03\jre\lib\sunrsasign.jar;D:\bea\jdk141_03\lib\dt.jar;D:\bea\jdk141_03\lib\htmlconverter.jar;D:\bea\jdk141_03\lib\tools.jar" DBTest
[Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
大意是Connection reset(连接重置),不知为什么?我用JDBC-ODBC桥连接时就没有问题。
String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs";
我把此句的localhost改成127.0.0.1和计算机名都一样。