我在windows下配置了一个叫lm的数据源 用户名和密码都是lm,已经把SQLServer的三个包打进去了
我要JDB_ODBC连接
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection cn=DriverManager.getConnection("jdbc:odbc:lm","lm","lm");
返回的结果不报错 但是取到的是个空连接
我用
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
cnn = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.1.102:1433;databasename=Northwind","lm", "lm");
是可以连接的
为什么啊?????????????????????????
我要JDB_ODBC连接
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection cn=DriverManager.getConnection("jdbc:odbc:lm","lm","lm");
返回的结果不报错 但是取到的是个空连接
我用
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
cnn = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.1.102:1433;databasename=Northwind","lm", "lm");
是可以连接的
为什么啊?????????????????????????
改一下试试
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
我取到的connection是个NULL运行中没有异常 也不报错
为什么在工程里那样写就不能连
是不是还要加什么包~~~~~~~~~~~~~~~~
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(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at com.db.ConnectTosql.<init>(ConnectTosql.java:21)
at com.db.ConnectTosql.main(ConnectTosql.java:43)
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(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at com.db.ConnectTosql.<init>(ConnectTosql.java:21)
at com.db.ConnectTosql.main(ConnectTosql.java:43)
这个问题打上sqlserver2000 的补丁。
我用的是2000Server 系统
因该报错的
url = "jdbc:odbc:student";
user = "sa";
pwd = "sa";
Class.forName(driver);
con = DriverManager.getConnection(url, user, pwd);
出现了这个异常