请输入账号:请输入密码:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at common.DataBaseManager.connectSQLServer(DataBaseManager.java:30)
at common.DataBaseManager.<init>(DataBaseManager.java:17)
at server.Login.getName(Login.java:20)
at server.Login.doLogin(Login.java:45)
at ui.AtmUi.main(AtmUi.java:10)
Exception in thread "main" java.lang.NullPointerException
at common.DataBaseManager.makeStatement(DataBaseManager.java:39)
at common.DataBaseManager.<init>(DataBaseManager.java:18)
at server.Login.getName(Login.java:20)
at server.Login.doLogin(Login.java:45)
at ui.AtmUi.main(AtmUi.java:10)
在SQL2000下运行没有问题,换到自己电脑上连接就出问题了,以前也是这样连得,但是重装JDK后在用同样的方法连就出错了
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at common.DataBaseManager.connectSQLServer(DataBaseManager.java:30)
at common.DataBaseManager.<init>(DataBaseManager.java:17)
at server.Login.getName(Login.java:20)
at server.Login.doLogin(Login.java:45)
at ui.AtmUi.main(AtmUi.java:10)
Exception in thread "main" java.lang.NullPointerException
at common.DataBaseManager.makeStatement(DataBaseManager.java:39)
at common.DataBaseManager.<init>(DataBaseManager.java:18)
at server.Login.getName(Login.java:20)
at server.Login.doLogin(Login.java:45)
at ui.AtmUi.main(AtmUi.java:10)
在SQL2000下运行没有问题,换到自己电脑上连接就出问题了,以前也是这样连得,但是重装JDK后在用同样的方法连就出错了
如果不是,检查一下防火墙的设置,然后检查一下下面设置是否开启:打开SQL Server Management Studio-->在左边[对象资源管理器]中选择第一项(主数据库引擎)-->右键-->方面-->在方面的下拉列表中选择[外围应用配置器]-->将RemoteDacEnable置为True.
请输入账号:请输入密码:Exception in thread "main" java.lang.NullPointerException
at common.DataBaseManager.makeStatement(DataBaseManager.java:39)
at common.DataBaseManager.<init>(DataBaseManager.java:18)
at server.Login.getName(Login.java:20)
at server.Login.doLogin(Login.java:45)
at ui.AtmUi.main(AtmUi.java:10)用的08驱动一样出错
Exception in thread "main" java.lang.NullPointerException
at common.DataBaseManager.makeStatement(DataBaseManager.java:39)
at common.DataBaseManager.<init>(DataBaseManager.java:18)
at server.Login.getName(Login.java:20)
at server.Login.doLogin(Login.java:45)
at ui.AtmUi.main(AtmUi.java:10)
改了之后是这个错误,,2000的连接方式跟2008是不是不一样,
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=atm";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver")
.newInstance();
conn = DriverManager.getConnection(url, "plc", "plc7408195");
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
}
这样连有什么问题
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver")
.newInstance();
conn = DriverManager.getConnection(url, "plc", "plc7408195");
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
}