By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,179 Members | 2,175 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,179 IT Pros & Developers. It's quick & easy.

Timeout expired.....

P: n/a
Hi

Iam working on asp.net web application and my web server is running on win2k
and data base is MS SQL 2000. Iam getting the below are error very frequently.

"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 havent used pooling attributes in my connection string and in IIS i had
put connections to unlimited....and most of the places i used datareaders and
iam closing datareaders after consuming them and explicitly closing the
connection as well as disposing the connection. But still iam getting the
above error.

when i see my Activity status in SQL Server under current activity of
management menu....i can see lot of connections are under sleep mode. i
re-started SQL server and even IIS and even iam doing the same for every 3 to
4 days.

I will be very thankfull to you if any one can mail me the solution.

Thanks in advance.

Regards
Vamsi
Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Vamsi:

If this problem occurs after a long period of time, you might need to
review your code and make absolutely sure you dispose the connections
when you are done. Do you have the dispose inside of a finally or
using statement?

Connection pooling happens by default with the SqlConnection class,
you don't need to put a special attribute in the string.

You might try to stress test pieces of your application with the
perfmon tool running to how your application uses connections.

--
Scott
http://www.OdeToCode.com

On Thu, 9 Sep 2004 23:35:01 -0700, "Vam$y"
<Va***@discussions.microsoft.com> wrote:
Hi

Iam working on asp.net web application and my web server is running on win2k
and data base is MS SQL 2000. Iam getting the below are error very frequently.

"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 havent used pooling attributes in my connection string and in IIS i had
put connections to unlimited....and most of the places i used datareaders and
iam closing datareaders after consuming them and explicitly closing the
connection as well as disposing the connection. But still iam getting the
above error.

when i see my Activity status in SQL Server under current activity of
management menu....i can see lot of connections are under sleep mode. i
re-started SQL server and even IIS and even iam doing the same for every 3 to
4 days.

I will be very thankfull to you if any one can mail me the solution.

Thanks in advance.

Regards
Vamsi


Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.