UC知道JSP程序连不上SQLServer2000数据库！
来源：百度知道 编辑：UC知道 时间：2024/06/16 11:45:31
JSP程序连不上SQLServer2000数据库！【】
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:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.jsp.a_jsp._jspService(a_jsp.java:104)
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:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.jsp.a_jsp._jspService(a_jsp.java:104)
下载个JDBC的驱动，你安装好后，把C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib目录下的msbase.jar，mssqlserver.jar，msutil.jar这三个jar文件拷贝到你TOMCAT安装目录下的\common\lib目录下就可以了
下面是微软官方SQL Server 2000 Driver for JDBC Service Pack 3的下载地址：
http://www.microsoft.com/downloads/details.aspx?FamilyId=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en#filelist
PS:如果是XP2的系统，要把SQLSERVER2000升级到SQL Server 2000 Service Pack 3才行哦，这个升级包，迅雷上有下
就是下载SQL SERVER 2000的JDBC驱动。
也可以用ODBC桥连接，其步骤如下：
1、建立SQL SERVER2000的ODBC数据源，通过“管理工具”中的“数据源（ODBC）”即可建立；
2、用下面的代码即可建立到数据库的连接
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn = DriverManager.getConnection(
"jdbc:odbc:ODBC数据源名;"+
"UID=用户名(用SA也可);PWD=密码;"+