使用微软提供的MS Sql Server JDBC驱动访问Sql Server2000出现的问题 - JavaBlog

使用微软提供的MS Sql Server JDBC驱动访问Sql Server2000出现的问题

安装了几个jsp源码项目，在IE中访问时总发现数据库中没有取到数据，数据库使用的是MS Sql Server2000。然后，写了一个测试连库的页面。测试页面返回如下错误：

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)

org.apache.jsp.JDBCForMSSQLServer

.jdbcForMSSqlServerTest_jsp._jspService(jdbcForMSSqlServerTest_jsp.java:106)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)

com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)

com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)

com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

java.sql.DriverManager.getConnection(DriverManager.java:525)

java.sql.DriverManager.getConnection(DriverManager.java:171)

org.apache.jsp.JDBCForMSSQLServer.jdbcForMSSqlServerTest_jsp._jspService(jdbcForMSSqlServerTest_jsp.java:71)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

直接使用访错误在网上一搜，发现是Sql Server 没有安装Sp3补丁，赶紧下了一个装上。

posted on 2007-06-27 00:18 eric.wen 阅读(761) 评论(0) 编辑收藏所属分类: jsp

常用链接

留言簿(2)

随笔分类

随笔档案

文章分类

收藏夹

博客收藏

搜索

最新评论

阅读排行榜

评论排行榜


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻 Chat2DB C++博客博问管理
相关文章: java访问Sql server 2005补充两个问题使用微软提供的MS Sql Server JDBC驱动访问Sql Server2000出现的问题