执行这么一个方法:
public static Connection getConnection() throws SQLException, ClassNotFoundException{// String driverName = "net.sourceforge.jtds.jdbc.Driver";
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbUrl = "localhost:1433/" ;
String databaseName = "ncsdb";
String user = "sa";
String password = "";
// String dbName = "jdbc:jtds:sqlserver://" + dbUrl + databaseName;
String dbName = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ncsdb";
Connection conn = null;
try{
Class.forName(driverName);
conn = DriverManager.getConnection(dbName,user,password);
}catch(ClassNotFoundException e){
e.printStackTrace();
throw e;
}catch(SQLException e){
e.printStackTrace();
throw new SQLException();
}
return conn;
}抛异常:
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:171)
.....看不出哪儿有错啊,
用jtds也是一样有问题,,
public static Connection getConnection() throws SQLException, ClassNotFoundException{// String driverName = "net.sourceforge.jtds.jdbc.Driver";
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbUrl = "localhost:1433/" ;
String databaseName = "ncsdb";
String user = "sa";
String password = "";
// String dbName = "jdbc:jtds:sqlserver://" + dbUrl + databaseName;
String dbName = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ncsdb";
Connection conn = null;
try{
Class.forName(driverName);
conn = DriverManager.getConnection(dbName,user,password);
}catch(ClassNotFoundException e){
e.printStackTrace();
throw e;
}catch(SQLException e){
e.printStackTrace();
throw new SQLException();
}
return conn;
}抛异常:
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:171)
.....看不出哪儿有错啊,
用jtds也是一样有问题,,
解决方案 »
- 如何将日期时间型转换为 YYYMMDDhhmmZZZ格式
- 求教一个有关java-socket的小程序
- 分不多, JLIST换了GIF不能正常显示。。实在是受不鸟了~~
- 求JAVA方面的视频教程
- 词法分析器问题!!!!
- HttpClient post 关于post数据为中文的问题
- 一个Regular Expression的问题!!
- 求一段简单的java代码,在线等,谢谢
- 求effective java简体中文版
- Failed to load Main-class manifest attribute from Test.jar是怎么产生的?
- 这个问题如何解决呢?
- 调用oracle存储过程,如何得到这样的返回值??
// String driverName = "net.sourceforge.jtds.jdbc.Driver";
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbUrl = "localhost:1433/" ;
String databaseName = "ncsdb";
String user = "sa";
String password = "";
// String dbName = "jdbc:jtds:sqlserver://" + dbUrl + databaseName;
String dbName = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ncsdb";
你也不嫌麻烦,写这么多,2句话就可以搞定的
另外,看你的错误提示,给你个建议,你手动用sa的身份登陆下你的sqlserver数据库,如果可以进去,然后在判断下你的sqlserver是否打了sp3的补丁,如果没打,那么应该是打上就可以了
其次如果你用的xp系统的话,sqlserver最好打上sp3。2000好像可以不打。不过出于安全考虑都打上吧,又不吃亏……