sql server 2000 jdbc 连接 Connection 出错

来源：百度知道 编辑：UC知道 时间：2024/07/04 07:39:04
在连接sql server 时出现了以下的错误！！
url username passwd都正确

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.(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)

public Connection getConn() {
Connection conn = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433;DatabaseName=pubs";
String user="sa";
String pwd="";
conn=DriverManager.getConnection(url,user,pwd);
} catch (Exception e) {

e.printStackTrace();
}
return conn;
}

这是连接的正确方法，把这复制到你项目里，改下数据库密码，
还有导入jdbc驱动包。

oh my god!I don't know.