Help on Time out Error ???

[Guest]

Dear all,

I have an asp.net 1.1 application which collect data from an sql server
database
So far it was working fine and suddenly I get the following error :

"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"

To connect to the database I am using a single account, so I have normally
only one pool, and a single uinque connection string

What is going on ? how to solve ?

thnaks for your help
regards
serge

 

[Ranjan]

Hello serge,

I think you need to check how many open connections you have while the application
is running. You can use perfmon.exe to do this.

Normally it would be better if you use the using construct to open any connections,
its safer that way, as you would not be missing out on closing any connections.



HTH,
r.

 

[Guest]

How to check open connection with perfmon ??

What to you mean in your last point ?

 

[Ranjan Sakalley]

Hello serge,

You can see Peter's article on this (http://codebetter.com/blogs/peter.van.ooijen/archive/2005/11/04/134266.aspx)

The last point is better explained here http://davidhayden.com/blog/dave/archive/2005/01/13/773.aspx

HTH,
r.