win2003 +sql server2000+jdbc联不上 急!急!急!

[bcdavid]

win2003 +sql server2000+jdbc联不上
sql server2000以近　打了sp3
听说没希望的，2003不向下兼容

大家有没有遇到过　这样的问题
Starting service Tomcat-Standalone
Apache Tomcat/4.0.4

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis
hing 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 Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
ource)
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:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.bitmechanic.sql.ConnectionPool.createDriverConnection(ConnectionP
ool.java:468)
at com.bitmechanic.sql.ConnectionPool.getConnection(ConnectionPool.java:
407)
at com.bitmechanic.sql.ConnectionPoolManager.connect(ConnectionPoolManag
er.java:442)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.dci.common.DBConnectionService.getConnection(DBConnectionService.
java:77)
at com.dci.common.DBConnectionService.getConnection(DBConnectionService.
java:130)
at com.dci.common.ApplicationContext.getConnection(ApplicationContext.ja
va:260)
at com.dci.common.ApplicationContext.retrieveSysParameter(ApplicationCon
text.java:145)
at com.dci.common.ApplicationContext.<init>(ApplicationContext.java:44)
at com.dci.common.web.ExtendedActionServlet.init(ExtendedActionServlet.j
ava:38)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:918)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:81
0)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:3279)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3
421)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:638)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
at org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:506
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis
hing 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 Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
ource)
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:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.bitmechanic.sql.ConnectionPool.createDriverConnection(ConnectionP
ool.java:468)
at com.bitmechanic.sql.ConnectionPool.getConnection(ConnectionPool.java:
407)
at com.bitmechanic.sql.ConnectionPoolManager.connect(ConnectionPoolManag
er.java:442)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.dci.common.DBConnectionService.getConnection(DBConnectionService.
java:77)
at com.dci.common.DBConnectionService.getConnection(DBConnectionService.
java:130)
at com.dci.common.ApplicationContext.getConnection(ApplicationContext.ja
va:260)
at com.dci.common.ApplicationContext.getUserName(ApplicationContext.java
:214)
at com.dci.common.ApplicationContext.<init>(ApplicationContext.java:53)
at com.dci.common.web.ExtendedActionServlet.init(ExtendedActionServlet.j
ava:38)
at javax.servlet.GenericServlet.init(GenericServlet.java:258)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:918)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:81
0)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:3279)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3
421)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:638)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343
)
at org.apache.catalina.core.StandardService.start(StandardService.java:3
88)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:506
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:781)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)

[biggie]

程序片段贴出来，应该是程序问题

[wafer_w]

classpath设置了没有？

[luckyfanjian]

好像是网络连接的问题！socket的问题！

[hhue]

用tomcat4.1.24就可以了

[bcdavid]

嗯 同上， 好像在win2003 中 不让sql2000的jdbc访问这个socket了， 不知道有没有人在win2003中用jdbc 连过sql2000,
同样的代码放在xp,win2000都没问题。

[wafer_w]

那肯定是MS搞的鬼三

[yjsyjs]

classpath设置了没有jdbc

[bcdavid]

MS 真受不了， 好想要用sql 2003了， 竟然不向下兼容。 难道是不向下对jdbc兼容。

[阿嚏个技术]

跟我的情况一样。java连接数据库时提示socket错。
环境是一样的，出错也一样。但我在WIN2003下，telnet 本地的1433端口竟然连不上，用netstat -na也没有看到1433端口在侦听，我想是不是SQL2000在WIN2003下的问题啊。不过用ODBC倒是能连上SQL

[bcdavid]

有人解决过这个问题吗？

[wangchq]

把你的2003的安全级别调低

[lglg930]

关注，，，

[longfeisoft]

用的2003企业版吧,我让他给烦死了,2003内置了防火墙,什么事都管,个人要用的话,还是先把安全级别调低吧,你的问题就出在ms2003的破东西上了...

[wqfsw]

我也是在weblogic上配置连接池，也出了同样的错误，我第一感觉就告诉我win2003的问题。
我晕死了。

[vcvj]

我的win2k3+jdbc for sql2k用了n次

一切ok

[bcdavid]

恩 楼上？ 怎么用的 ,why can't me?

[pguard]

md,我现在也是遇到这个问题，程序瘫痪了

[vcvj]

i'm using Windows 2003 server beta.aha