Question

java用JDBC连接SQL2005时候报错

com.microsoft.sqlserver.jdbc.SQLServerException: 无法打开登录所请求的数据库 "Shop"。登录失败。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(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 com.dao.impl.BaseDao.getConn(BaseDao.java:22)
at com.dao.impl.StorageDaoImpl.order(StorageDaoImpl.java:40)
at com.test.OrderTest.main(OrderTest.java:17)
都没写错啊 请问端口那怎么改 步骤详细点 谢谢

Answer 1

数据库没有连接上。
解决方案：
1.查看代码 是否有字符写错。驱动 连接等是否正确。
2.检查驱动包。

Answer 2

应该是没添加jar包

Answer 3

应该是数据库连接失败的原因......

Answer 4

把newdb的端口号设为1433,动态端口号设为零
再看看数据库驱动包导入没，要放在lib下面。