Cannot create PoolableConnectionFactory ([Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)最重要的原因在哪里？
最近一直在弄这个问题，但是也一直没有进展……是sql 补丁的问题吗？ 我下载了 sp3，sp4 但是装上没见任何异样的效果！不知道怎么弄了。 顺便问下， sp3，sp4 装上怎么看是否成功？
异常代码如下：
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at ch06.jndi.GetDataBean.getFoods(GetDataBean.java:36)
at org.apache.jsp.ch06.show_jsp._jspService(show_jsp.java:106)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)
Caused by: 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 org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
... 21 more
请帮帮忙！
[解决办法]
下载microsoft sqlserver 2000 jdbc 比较新的那个.
打开sqlserver 2000企业管理器，打开服务器属性，安装好了，上边会写sp4
[解决办法]
补丁达到sp4
去官方网站打
[解决办法]
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
看看数据库的1433端口打开了没有.
具体步骤: Run --> cmd --> netstat -an -p TCP
查一下有没有 1433端口(没有则表示你的数据库SQL SERVER 2000的补丁包 SP3或以上版本 未打上,打上补丁包，这个1433端口会自动打开的)。
[解决办法]
[size=11px]在 SP4 的安装文件夹下还有个 stup。bad 要运行一下才算真正的升级了哦！[/size]
[解决办法]
telnet localhost 1433
打开服务器一直没有关,那证明补丁打上了.好像你的驱动有问题.
[解决办法]
讨厌的 SP4
1 下载 SP4
2 运行，注意他会让你选择一个目录，比如 C:\sqlsp4
3 转到那个目录
4 再次运行里面的 setup.bat
许多人运行到第2步就以为升级成功了，这个真是微软的失败，为何不直接启动那个setup呢？搞不懂！
