JDBC for SQL Server2000驱动加载了可是报错

[Robby1984]

import java.sql.*;

public class DBColumn
{
public static void main(String[] args)
{
Connection con=null;
Statement sm=null;
ResultSet rs=null;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("驱动程序已加载");

con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs","sa","ok");
System.out.println("OK,成功连接到数据库");
sm=con.createStatement();
rs=sm.executeQuery("select * from publishers");
while(rs.next())
{
System.out.println(rs.getString("pub_name"));
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}

出现异常
驱动程序已加载
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.<init>(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
ource)
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 DBColumn.main(DBColumn.java:19)
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
Press any key to continue...

[Paul_123]

你用的是win2000还是winXP，你先看看是否加入了sql的sp4补丁，你可以去microsoft的网站去找，那里有下的这个问题应该就是这个的错误

[xiangbo520]

请给你的SQL Server2000打SP4(service pack 4)的补丁,你的系统应该是XP或者2003,在这两个操作系统下使用JDBC for SQL Server2000需要给SQL Server2000打SP4(service pack 4)的补丁.

[xiangbo520]

在微软的网站上有下载

[3feetcat]

打补丁

[Robby1984]

可是怪就怪在我导了那三个包，也打了sp4的补丁

[xiariguji]

我曾经出现过这样的问题.
有两种可能.1:tomcat的几个文件没拷过来2:没有打SP4补丁

[jobs002]

需要sp4的补丁

[wjhalex]

我也曾有过同样的问题,打上SP4补丁,顺便也把端口1433也改下,还有还要为那三个JAR文件设置环境变量CLASSPATH,再把它们也复制到Tomcat 的lib目录下,