Application Connection with MSSQL problem

Hi,

About 20 instances of my application is connecting to a single DB (MSSQL Standard 8.0 ). Earlier all the instances could connect, but after sometime, I am getting the following error.

It would be great if anyone facing such problem earlier and resolved could help.

SQL connection get returned error. Message:[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. SQLState :[08001] ErrorCode : [0]

Stack Tracecom.ibm.websphere.ce.cm.StaleConnectionException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

at java.lang.reflect.Constructor.newInstance(Native Method)

at com.ibm.ejs.cm.portability.PortabilityLayerImpl.translateException(PortabilityLayerImpl.java:263)

[751 byte] By [Ingudama] at [2007-10-1 18:43:32]
# 1
Hi Ingudam,Are the earlier instances closing the connection when they're done? Perhaps SQL Server has all its connections used up.CB.
ChrisBoya at 2007-7-11 13:49:06 > top of Java-index,Developer Tools,Debugging and Profiling Tool APIs...
# 2
hi inudam, I have the same problem as you,were you able to find out a solution?any hint that could help me?thanks
eeelnicoa at 2007-7-11 13:49:06 > top of Java-index,Developer Tools,Debugging and Profiling Tool APIs...