Home All Groups Group Topic Archive Search About

Conneciton pooling ? URGENT HELP !!!

Author
19 Feb 2006 3:28 PM
Ahmed Jewahar
Hi,

I have a asp.net application (vb) connecting SQL2k server. I'm using a
common login for connecting to SQL datrabase. The reason to use common
login in order SQL to re-use connection from "pooling" (do not know much
about connection pooling"). But, I'm getting sometime error from my web
applicaiton "reached maximum pooling". In the conneciton string, shall I
add any paramter such as "pooling=true" ?

I also check "current # connection pool" in the "perfmon" it always
shows 100.

Pls advise..

*** Sent via Developersdex http://www.developersdex.com ***

Author
19 Feb 2006 3:46 PM
Marwan Tarek
Hello Ahmed,

increase the time out property in the connection string

Marwan Tarek
http://www.sharepointblogs.com/marwantarek/

Show quoteHide quote
> Hi,
>
> I have a asp.net application (vb) connecting SQL2k server. I'm using a
> common login for connecting to SQL datrabase. The reason to use common
> login in order SQL to re-use connection from "pooling" (do not know
> much about connection pooling"). But, I'm getting sometime error from
> my web applicaiton "reached maximum pooling". In the conneciton
> string, shall I add any paramter such as "pooling=true" ?
>
> I also check "current # connection pool" in the "perfmon" it always
> shows 100.
>
> Pls advise..
>
> *** Sent via Developersdex http://www.developersdex.com ***
>