这是在NETBEANS 里的错误信息:欢迎各位大虾指点
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:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.wgh.DB.connDB.getConnection(connDB.java:38)
at com.wgh.DB.connDB.executeQuery(connDB.java:57)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:49)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)
警告: DbConnectionManager.getConnection() 获得数据库链接失败.链接类型:com.microsoft.jdbc.sqlserver.SQLServerDriver
链接位置:jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_shop
用户/密码sa/
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:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.wgh.DB.connDB.getConnection(connDB.java:38)
at com.wgh.DB.connDB.executeQuery(connDB.java:57)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:49)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)
警告: DbConnectionManager.getConnection() 获得数据库链接失败.链接类型:com.microsoft.jdbc.sqlserver.SQLServerDriver
链接位置:jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_shop
用户/密码sa/
解决方案 »
- SSH 调用 存储过程 高手来指点一二 感激不尽 深夜在线等
- struts2中的<s:select标签,如何选择某一选项后触发点击时间呢。
- jsp跳转,谢谢
- 关于登录后欢迎对话框的问题
- 为什么报hibernate.cfg.xml not fund呢?郁闷了好几天了。。。。。
- ResultSet中,怎样取得正在输出的是第几行?
- ant编译报错,怎么说包不存在啊
- 问一个送分的问题,请各位老大帮下忙!
- HELP,TOMCAT ...
- 关于eclipse使用summernote图标不显示
- 如何隐藏frameset左侧树结构
- 在struts 1.2中,关与一个form 的多个 submit问题``````````急````
1, 没有 sp3补丁程序
2, sql 服务器没开.
打开sql server的企业管理器,如果没有默认窗口打开,请新建一个窗口,然后找到sql server组下面的任一个服务器,右键菜单选择属性,在常规选项卡中可以看到版本号,如图1所示:
图1版本为8.00.194(RTM),这样的显示,表明还没有安装SQL Server SP3。
如果打开查询分析器看帮助菜单中的“关于SQL查询分析器”,会看到如图2所示画面:
图2
此处只显示了8.00.194,显然不如图1中的直观易记。选择\\toolserver\数据库安装\Microsoft SqlServer\SQLSERVER2000\SQLSERVER SP3\中文\chs_sql2ksp3.exe,文件大小55M的这个文件。安装时提示解压到才c:\sql2ksp3,如图3:
图3
解压完毕,请到c:\sql2ksp3目录下找到setup.bat文件双击实行安装即可。
安装完sp3,再来看刚才那个地方的版本号,会显示为8.00.760(SP3),如图4:
图4
此时已经显示为8.00.760(SP3)了,如果此时在查询分析器中查看会看到如图5所示:
图5请记住,如果版本号显示为8.00.194(RTM)就表明没有安装SP3,安装后版本则显示为8.00.760(SP3)。如果你打开了企业管理器中的帮助菜单中的“关于Microsoft Management Console”的话得到的是系统控制台的版本信息啊,如图6:
图6
就是mmc系统控制台,你可以在开始菜单--运行中键入mmc,然后打开帮助菜单,查看关于,你将得到同样的信息。这里显示的版本是系统的版本号,系统安装的SP,而不是sql server
http://blog.csdn.net/xuyanli/archive/2008/04/30/2347091.aspx