urgent: connection pooling error

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
Thu Nov 11 18:23:08 CST 2004

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)


"Param R." <pr@nospam.com> wrote in message
news:%23dCNwGDyEHA.3808@tk2msftngp13.phx.gbl...
| 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
Fri Nov 12 23:11:51 CST 2004

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

thanks!

"bruce barker" <nospam_brubar@safeco.com> wrote in message
news:OxaDK3EyEHA.3976@TK2MSFTNGP09.phx.gbl...
> thre are two common causes:
>
> 1) coding error leading to not closing connections
> 2) too many concurent request (more requests running than pool size).
> thise
> 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)
>
>
> "Param R." <pr@nospam.com> wrote in message
> news:%23dCNwGDyEHA.3808@tk2msftngp13.phx.gbl...
> | 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
Mon Nov 15 17:42:11 CST 2004

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

TIA!

"bruce barker" <nospam_brubar@safeco.com> wrote in message
news:OxaDK3EyEHA.3976@TK2MSFTNGP09.phx.gbl...
> 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)
>
>
> "Param R." <pr@nospam.com> wrote in message
> news:%23dCNwGDyEHA.3808@tk2msftngp13.phx.gbl...
> | 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
> |
> |
>
>