urgent: connection pooling error

[Param R.]

Hi all, I have a web service that opens a sqlconnection to the db and does
some work. Just recently I have begun getting the following error on a
frequent basis:

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 have verified that my web service is closing connections. Why is this
happening? Can I increase the max pool size? How?

thanks,
Param

 

[bruce barker]

thre are two common causes:

1) coding error leading to not closing connections
2) too many concurent request (more requests running than pool size). this
is anot very likly, as you generaaly run out of threads first.

i'd guess the first. if its the second increase the pool size in the
connection string.


-- bruce (sqlwork.com)


| Hi all, I have a web service that opens a sqlconnection to the db and does
| some work. Just recently I have begun getting the following error on a
| frequent basis:
|
| 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 have verified that my web service is closing connections. Why is this
| happening? Can I increase the max pool size? How?
|
| thanks,
| Param
|
|

 

[Param R.]

Where can I find a sample connection string to increase the pool size?

thanks!

 

[Param R.]

This error never surfaced in .net 1.0. Any ideas? Ever since I upgraded to
..net 1.1 sp1 it has started.

TIA!