我用jdbc连接sqlserver2000数据库:sqlserver2000 名称:sherman
服务器: win2000 server sp4 地址:192.168.10.141
jdk:1.4
驱动:在微软网站下的 sqlserver2000 for jdbc sp2用sqlserver客户端连接数据库,没问题!
在客户端 telnet 192.168.10.141:1433,没有问题!java代码:import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;public class Test {
public Test() {
}
public static void main(String args[]) throws SQLException {
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERVANDDB="jdbc:microsoft:sqlserver://192.168.10.141:1433;DatabaseName=sherman";
String USER="ning";
String PWD="ning";
Connection con =null;
try{
Class.forName(CLASSFORNAME).newInstance();
con=DriverManager.getConnection(SERVANDDB,USER,PWD);
System.out.println("ok");
}catch(Exception e){
System.out.println("error");
e.printStackTrace();
}
if (con != null) {
con.close();
}
}
}
报错:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]无法打开登录 'sherman' 中请求的数据库。登录失败。 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)error at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(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.ning.sqlserver.Test.main(Test.java:26)
请问是什么原因?如何解决???
服务器: win2000 server sp4 地址:192.168.10.141
jdk:1.4
驱动:在微软网站下的 sqlserver2000 for jdbc sp2用sqlserver客户端连接数据库,没问题!
在客户端 telnet 192.168.10.141:1433,没有问题!java代码:import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;public class Test {
public Test() {
}
public static void main(String args[]) throws SQLException {
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SERVANDDB="jdbc:microsoft:sqlserver://192.168.10.141:1433;DatabaseName=sherman";
String USER="ning";
String PWD="ning";
Connection con =null;
try{
Class.forName(CLASSFORNAME).newInstance();
con=DriverManager.getConnection(SERVANDDB,USER,PWD);
System.out.println("ok");
}catch(Exception e){
System.out.println("error");
e.printStackTrace();
}
if (con != null) {
con.close();
}
}
}
报错:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]无法打开登录 'sherman' 中请求的数据库。登录失败。 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source) at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)error at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(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.ning.sqlserver.Test.main(Test.java:26)
请问是什么原因?如何解决???
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货