"java.sql.exception:[microsoft][sqlserver 2000 driver forJDBC] connection reset"

[deepti singal]

Hi Everyone,

I got this error

java.sql.SQLEXCEPTION :[microsoft][sqlserver 2000 driver forJDBC] connection reset"

while executing

"$pstmt executeQuery "SELECT InstallReqID FROM STAutorequest where ID='$iReqID'"

(procedure "GetInstallID" line4)

invoked from within

"GetInstallID $iReqID"

(procedure "CreateEmailReport" line26)

invoked from within

please reply asap

Thanks

[Sagar Rohankar]

Can you paste connection details here, like db url and other extra param you are using for creating connection object.

[deepti singal]

Hi Sagar,

Thanku for replying.This exception started coming up when we changed "SQL Enterprise Manager to MS SQL 2005 " otherwise things were working fine earlier

Please tell me is there any limit on the no of connections that are supported by MS SQL 2005? and how can i see the active connections (any query to extract this info?)

Do help me if you have some solution

Thanks in advance

[Sagar Rohankar]

deepti singal wrote:This exception started coming up when we changed "SQL Enterprise Manager to MS SQL 2005 " otherwise things were working fine earlier

Pardon my little knowledge of SQl Server, but try updating/changing JDBC driver for MS SQL 2005.

Please tell me is there any limit on the no of connections that are supported by MS SQL 2005? and how can i see the active connections (any query to extract this info?)

The concurrent connection limit is something configure in db server, please check db config. For seeing active connections, you have to query db for that, and I don't how to that, googling will help.

[deepti singal]

I don't think it is driver issue because this exception comes up in 2 out of 10.due to this our work is hampered

Do you need more information ?

[deepti singal]

Please tell me how to check db config?