jdbc for SqlServer2000的驱动包已经引入,端口1433,登陆数据库服务器用户密码都没错,连接时出现如下错误:
“java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.”错误的代码行是:“conn=DriverManager.getConnection(url,user,psw);”哪位高手指点下?谢谢
“java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.”错误的代码行是:“conn=DriverManager.getConnection(url,user,psw);”哪位高手指点下?谢谢
解决方案 »
- 请大家推荐一个压力测试工具
- Spring3.1.1 + Hibernate4.1.4 声明事务配置不成功...
- 各位搞手,进来救命啦!!
- StandardWrapperValve[action]: Servlet.service() for servlet action threw exception异常
- 初涉struts facade模式
- 做B/S开发.NET和Java哪个更有前途
- jbpm:我把jbpm发布到jboss中,在ejb中调用jbpm,当进入node时触发action..
- excel导出中文,早linux部署下得到的为乱码,在window下没问题,求解决??
- 在编码过程中log4j是怎么定义的?
- jb7中两种建立data source的方法
- int and Interger
- java中gregoriancalendar中的用法!
去网上下个sql server的sp4补丁就好了
package utils;import java.sql.Connection;
import java.lang.ClassNotFoundException;
import java.sql.DriverManager;
import java.sql.SQLException;public class ConnectionDB {
public static Connection getConnection()throws ClassNotFoundException{
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=libSystem";
String user="qz";
String psw="qz";
Connection conn=null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection(url,user,psw);
conn.setAutoCommit(false);
return conn;
} catch (SQLException e) {
System.out.println("链接数据库失败");
e.printStackTrace();
}
return 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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at utils.ConnectionDB.getConnection(ConnectionDB.java:16)
我遇过这种错误记得我数据库访问把安全性秘密去了。。在外围适配器,远程服务改 选中htt协议就OK 啦。