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