连接SQL Server2000问题

Question

我用的驱动程序是sqljdbc.jar
程序如下：
public class AccessDAO {
private String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; private String first_url = "jdbc:sqlserver://10.10.9.13:1433"; String dbuser = "sa"; String dbpasswd = "sms_ld"; private String dbname = "jsmartsales"; public AccessDAO(String dbname) {
this.dbname = dbname;
} public Connection getConnection(){
System.out.println("Enter AccessDAO......"+Calendar.getInstance().getTime());
try {
Class.forName(driverName);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("未找到驱动程序......");
e.printStackTrace();
}
System.out.println("After forName......"+Calendar.getInstance().getTime());
String url = first_url + ";DatabaseName="+dbname;
Connection conn = null;
System.out.println("before getConnection......"+Calendar.getInstance().getTime());
try {
conn = DriverManager.getConnection(url,dbuser,dbpasswd);
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println("连接数据库失败");
e.printStackTrace();
}
System.out.println("连接数据库成功");
System.out.println("after getConnection......"+Calendar.getInstance().getTime());
return conn;
}
报错：com.microsoft.sqlserver.jdbc.SQLServerException: 到主机  的 TCP/IP 连接失败。 java.net.ConnectException: Connection timed out: connect
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at AccessDAO.getConnection(AccessDAO.java:34)
at LoginServlet.doGet(LoginServlet.java:22)

Answer 1

SQL Server 的sp4补丁吧！
前段时间就是因为没打补丁，出了些莫名其妙的错误。