Help on Time out Error ???

[serge calderara]

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.

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

[serge calderara]

How to check open connection with perfmon ??

What to you mean in your last point ?
"Ranjan" wrote:

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.

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 Sakalley]

Hello serge,

You can see Peter's article on this (http://codebetter.com/blogs/peter.va...04/134266.aspx)

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

HTH,
r.

How to check open connection with perfmon ??

What to you mean in your last point ?

"Ranjan" wrote:

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.

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