当前页面: 开发资料首页 → JSP 专题 → 急!jsp页面中连接windows 2003 server + SQL server 2000 企业版出错:establishing socket error
急!jsp页面中连接windows 2003 server + SQL server 2000 企业版出错:establishing socket error
摘要: 急!jsp页面中连接windows 2003 server + SQL server 2000 企业版出错:establishing socket error
index.jsp
————————————
...
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
}
catch(Exception e)
{
out.println(e);
}
...
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
......
}
catch(Exception e)
{
System.out.println(e);
}
...
运行后出现:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
在XP SP2下也是这样,不知道怎么回事.
sp3补丁包问题:
如果你在编译时出现下列问题 那么你需要下载并安装sp3补丁包
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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Test.main(Test.java:14)
自己去下载sql server 2000 sp3升级包