日期:2014-05-18  浏览次数:20618 次

对方的ip修改后,为什么我再也连接不上他的数据库,急啊!
他的ip修改后,我在程序里已经修改了,为什么我就我就是连接不上呢?报错:
改回原来的ip我就能连接的上.修改后其他人能连接上,我却连接不上,什么原因?

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   com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:68)
at   com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:87)
at   com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.acquireResource(C3P0PooledConnectionPool.java:83)
at   com.mchange.v2.resourcepool.BasicResourcePool.assimilateResource(BasicResourcePool.java:884)
at   com.mchange.v2.resourcepool.BasicResourcePool.acquireUntil(BasicResourcePool.java:601)
at   com.mchange.v2.resourcepool.BasicResourcePool.access$400(BasicResourcePool.java:31)
at   com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1079)
at   com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:354)

------解决方案--------------------
你机器有问题 杀下毒 比较下你和同事的机器配置软硬件情况
------解决方案--------------------
Error establishing socket.

telnet一下SQL的端口,看是否可以访问。

检查防火墙之类的,还有SQL Server的补丁是否安装?
------解决方案--------------------
按 阿敏总司令 说的检查一下吧。很可能是 端口 没有开
------解决方案--------------------
除了说明它们设计的有缺陷外,不能说明别的。有效的方法是重装。这里面有许多默认的东西,你修改后它也不提示。包括防火墙