当前位置: 代码迷 >> Java Web开发 >> [讨论]使用weblogic8.1连接池连接sql server 2000
  详细解决方案

[讨论]使用weblogic8.1连接池连接sql server 2000

热度:500   发布时间:2006-06-30 22:25:36.0
[讨论]使用weblogic8.1连接池连接sql server 2000
测试连接时提示[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
我的weblogic安装目录在d盘,sql server 端口号是1433,
startWLS.cmd文件里设置如下
set CLASSPATH=%JAVA_HOME%\lib\tools.jar;%WL_HOME%\server\lib\weblogic_sp.jar;%WL_HOME%\server\lib\weblogic.jar;D:\bea\weblogic81\server\lib\msbase.jar;D:\bea\weblogic81\server\lib\msutil.jar;D:\bea\weblogic81\server\lib\mssqlserver.jar;%CLASSPATH%
为什么会提示错误?
搜索更多相关主题的帖子: server  jar  sql  lib  JAVA  

----------------解决方案--------------------------------------------------------
Error establishing socket.
你的错误类型是建立socket出错
看看是不是端口号不对
----------------解决方案--------------------------------------------------------

端口应该没有哦问题,给出错误提示
See com.borland.dx.dataset.DataSetException error code: BASE+66

com.borland.dx.dataset.DataSetException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

at com.borland.dx.dataset.DataSetException.a(Unknown Source)

at com.borland.dx.dataset.DataSetException.throwException(Unknown Source)

at com.borland.dx.dataset.DataSetException.SQLException(Unknown Source)

at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)

at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)

at com.borland.jdbcx.metadata.e.run(Unknown Source)

Chained exception:

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:512)

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

at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)

at com.borland.jdbcx.metadata.DatabaseInfo.openConnection(Unknown Source)

at com.borland.jdbcx.metadata.e.run(Unknown Source)


----------------解决方案--------------------------------------------------------
  相关解决方案