March 8, 2005 at 8:13 am
Hi Everyone,
I am having a random connectivity issue between my webserver and my database server since the last one week(it used to work fine prior to that). The error i get in my ASP.NET application is "Timeout Expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached" .
I tried terminal servicing into my webserver and creating an ODBC DSN to my database server. Sometimes it is able to create the DSN but at other times it gives one of the following errors
Connection failed:
SQLState: 'HYT00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired
OR
Connection failed:
SQLState: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
I have tried searching on the net but could not get any leads as to what the problem could be. We also ran the latest windows updates on the webserver but that did not solve the issue. Would really appreciate if someone could throw some light on the problem!
Thanks
March 9, 2005 at 12:34 pm
Last time I had a wierd issue like this, I downloaded a new MDAC and loaded it on all my servers involved. Got their components up to the same level. Fixed it right off.
March 9, 2005 at 7:16 pm
Beyond the previous I suggest look in the Windows Event Viewers logs to see if anything unusal. Could also be a network setting at either NIC or somewhere in between. To test send a continuos ping in the background to the remote location and run the app. When the app fails see if the PING failed also.
March 10, 2005 at 5:01 pm
If you google the following with the double-quotes, there's a ton of info:
"max pool size was reached"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply