java 连接sql2005报异常

nanjg 2015-02-28 04:02:42

引用

2015-2-28 15:35:42 com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
警告: ConnectionID:1 Prelogin error: host 10.5.69.250 port 1433 Unexpected end of prelogin response after 0 bytes read
2015-2-28 15:35:49 com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
警告: ConnectionID:1 Prelogin error: host 10.5.69.250 port 1433 Unexpected end of prelogin response after 0 bytes read
com.microsoft.sqlserver.jdbc.SQLServerException: 通过端口 1433 连接到主机 10.5.69.250 的 TCP/IP 连接失败。错误:“驱动程序收到意外的登录前响应。请验证连接属性，并检查 SQL Server 的实例正在主机上运行，且在此端口接受 TCP/IP 连接。该驱动程序只能与 SQL Server 2000 或更高版本一起使用。”。
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1355)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.Prelogin(SQLServerConnection.java:1151)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1054)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.xsmcard.struts.util.DB4_2005.connDb(DB4_2005.java:31)
at com.xsmcard.struts.util.DB4_2005.main(DB4_2005.java:137)
2015-02-28

执行耗时 : 15.219 秒

引用

ublic void connDb()
{
driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
uri = "jdbc:sqlserver://10.5.69.250:1433;DateBaseName=kjtx";
// user = "njg";
// password = "123456789";
user = "sa";
password = "123456789";
conn = null;
stmt = null;
rs = null;
try
{
Class.forName(driver);
conn = DriverManager.getConnection(uri, user, password);
//stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt = conn.createStatement();
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println((new StringBuilder("DBconn (): ")).append(classnotfoundexception.getMessage()).toString());
}
catch(SQLException ex)

12月，2014内这段连接代码正常。2月2015内不能用