弄了好久了,还是弄不好,不知道怎么会事,提示错误为: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 sqlserver.TestSqlJdbc.main(TestSqlJdbc.java:12)
源程序为:
package sqlserver;
import java.sql.*;public class TestSqlJdbc{ // 联接数据库的驱动程序,缺省值
public static void main(String args[]){
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
try {
Class.forName(driverName);
Connection conn = DriverManager.getConnection(url,"user","password");
String sql = "select * from test";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getInt(1));
System.out.println(rs.getString(1));
}
rs.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
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 sqlserver.TestSqlJdbc.main(TestSqlJdbc.java:12)
源程序为:
package sqlserver;
import java.sql.*;public class TestSqlJdbc{ // 联接数据库的驱动程序,缺省值
public static void main(String args[]){
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
try {
Class.forName(driverName);
Connection conn = DriverManager.getConnection(url,"user","password");
String sql = "select * from test";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getInt(1));
System.out.println(rs.getString(1));
}
rs.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
解决方案 »
- java定时器问题,请帮忙看看,谢谢了
- Jdk中的AudioPlayer有Bug?调用后不能返回??程序会一只运行◎!
- tomcat mysql连接
- 这句代码中的Object.class确切意思是什么,感觉很模糊。
- 请问在XP下安装JDK时,为什么会出现这样的错误的提示
- Applet 在appletviewer 运行正常,可是在IE里不正常
- Sun One Directory Server 5.2 安装问题,恳请高手们帮忙!
- 再开一贴(续)
- 新手请教:哪位帮忙看看这段程序(用Applet画折线图)参数是接收到了并付给了数组,可就是出不了图???
- 为兼容类型是什么情况? 找不出来问题在哪
- Jtable如何获取数据
- 请大侠帮忙啊,急!!!
是没打补丁
如果还不行就是没引包,jar包,引包就可一了.
不过还是不行啊!
如果用ODBC-JDBD桥接 数据库还是同样问题
就是数据库的问题
否则是驱动的问题
去下个驱动