Question

java 连接sql2005数据库问题

String classforname=
"com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url="jdbc:sqlserver://localhost:1433;"
+ "databasename=mydb";
Class.forName(classforname);
Connection con=DriverManager.getConnection(url,"sa","sa");
Statement sta=con.createStatement();

错误com.microsoft.sqlserver.jdbc.SQLServerException: 无法打开登录所请求的数据库 "mydb"。登录失败。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2532)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1929)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1917)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1061)
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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at BASIC.DBtoXML.main(DBtoXML.java:19)
已经见过数据库了。。请大虾帮忙。。。

Answer 1

“登录失败”，
估计是你的sqlserver 的数据库的用户验证有问题 ，你打开的是windows 验证模式，你要开混合验证模式。

Answer 2

定义出错了啊...
private static Connection con = null;

Answer 3

这是因为你没有叫MYDB的数据库

Answer 4

或许是sql2005的用户sa默认是123456

Answer 5

sa密码错误