Timeout error

We have an ASP.Net (framework 1.1) app that does a lot of database reads and
updates. The app has a dozen pages and we're about 90% done and all of a
sudden I'm getting this 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.

It's not happening in the same place each time. I added the max pool size
and pooling properties to my connection string and I'm still getting the
error.

"server=*****;database=*****;uid=*****;pwd=*****;pooling=true;Max pool
size=100;"

We use sqlcommand objects with datareaders to populate datagrids and
datalists. Whenever we create a connection we explicitly close it.

Thanks in advance,

DougS


.

Relevant Pages

  • Re: Close and Dispose argument
    ... > fact that even Microsoft is not clear on the issue. ... > connections from the pool is still a debate. ... > method removes the conneciton from the connection pool". ... > Your issue was forwarded to us here at Microsoft Courseware Support. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error in asp.net application
    ... "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." ...
    (microsoft.public.dotnet.framework.aspnet)
  • Close and Dispose argument
    ... here is an email conversation between me and Microsoft ... connections from the pool is still a debate. ... Programming with Microsoft ADO.NET" module 2, p 18: "Calling the Dispose ... method removes the conneciton from the connection pool". ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MinPoolSize behaviour
    ... Min Pool Size, The first time you open a connection we will open the 1 ... > Is the pool created forever? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Q:Multithreaded ADO.Net Connections Are Non Pooled?
    ... different you get a new pool. ... > the process/app domain differences, does running on a thread created by ... If you're using SSPI, each connection must be ... >> connect to the SQL Server machine, ...
    (microsoft.public.dotnet.framework.adonet)
Loading