|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Conneciton pooling ? URGENT HELP !!!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 *** 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 *** > |
|||||||||||||||||||||||