You can receive this error if you forget to close your database connections
when you are done with them. Take a look at Management-->Current
Activity-->Process Info in Enterprise Manager. If you see a lot.
Double-clicking on each activity will tell you the last command that was
run. If you see a lot of activities with the same command listed, search
your code for references to that command. If this is the case, Most likely,
you are forgetting to close the connection somewhere.
"Swanand Mokashi" <sw*****@swanandmokashi.com> wrote in message
news:u$**************@TK2MSFTNGP09.phx.gbl...
Are you using the same user name and password to connect to SQL Server (I
assume) , everytime you connect ?
If not you are NOT using the advantages of connection pooling.
--
Swanand Mokashi
Microsoft Certified Professional
http://www.swanandmokashi.com/
Home of the Stock Quotes, Quote of the day and Horoscope web services
"Trevor Hartman" <sy******@hotmail.com> wrote in message
news:O1**************@TK2MSFTNGP10.phx.gbl... Hi,
Every now and then (once a week maybe), I get this error on my page
saying 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 don't know anything about
connection pooling, but could someone give me a suggestion on how to
take care of this? It usually goes away by itself eventually, or I just
restart IIS.
Thanks - Trevor