JSP与数据库连接出错

来源：百度知道 编辑：UC知道 时间：2024/07/02 07:35:27
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 ComClass.DBCon.getCon(DBCon.java:68)
at ComClass.ConnWay.Query(ConnWay.java:28)
at org.apache.jsp.index_jsp._jspService(in

是不是没连上数据库啊？好像说是找不到数据源波！你用的是桥连接还是纯连啊？
桥连代码：Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:数据库名");
纯连代码：Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://服务器地址:1433;DatabaseName=数据库名","密码","用户名");

同时打开防火墙的tcp 1433和udp 1434端口

调试的时候服务器要打开的吧，你的数据库驱动应该都放到tomcat的lib文件夹下
你要不在sql server查询分析器中键入select @@version是不是8.00.2039 SQL Server 2000 SP4 记得端口默认是1433的

LZ，把你写的连接数据库的代码段发上来看看。