连接sqlserver数据库时的错误请帮忙

[_chenyunfeng_]

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

cnn = DriverManager.getConnection("jdbc:microsoft:sqlserver://gsjnchenyf:1433;databaseName=master","sa","aaaaaa");








java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]End of stream was detected on a read.

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(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(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at COM.test.exec(test.java:27)

at COM.test.main(test.java:80)

[_chenyunfeng_]

阿?没人帮忙啊

[wzjcntlqs]

你用查询分析器连一下看看，会不会出错，如出错贴出来看看

[bluemeteor]

jdbc:microsoft:sqlserver://gsjnchenyf:1433;databaseName=master
改为
jdbc:microsoft:sqlserver://gsjnchenyf:1433;databaseName=master;SelectMethod=cursor

[whobillion]

有可能是driver的问题，ＳＱＬＳｅｒｖｅｒ的版本是不是没打补丁

[hillMover]

Connection conn;
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;databaseName=master";

String user = "sa";
String password = "myPassword"
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
System.out.println("Connect successful!");
}
catch (Exception ex) {
ex.printStackTrace();
}

我试过了,能成功!
所以你的代码没问题.
你再查查看!

[bxh2dai]

楼上的有道理

[_chenyunfeng_]

有可能是sqlserver的问题吗?换台相同版本的服务器联就可以啊,