«

Hello,

I'm having a recurring error whenever I try to debug a
asp.net web page is retrieving data from a SQL server.
The error msg is:

"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."

Any ideas?

by default asp.net uses pooling on connection object and a pool of 25
objects is maintained.
i would advise you to check for open connections....
any errors during db call not handled (and explicitly calling con.close() )
would not release the connection to the pool

if you are releasing all objects and are still running out cause of the
heavy load... try specifying the pool size in connection string...

--
Regards,

HD

"Brian" <> wrote in message
news:00d601c3d7ba$8bef23a0$...
> Hello,
>
> I'm having a recurring error whenever I try to debug a
> asp.net web page is retrieving data from a SQL server.
> The error msg is:
>
> "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."
>
> Any ideas?
>

sorry
have a look at this article..

http://msdn.microsoft.com/library/de...esigntools.asp

think i mixed it up with thread pool...

--
Regards,

HD

"Hermit Dave" <> wrote in message
news:...
> by default asp.net uses pooling on connection object and a pool of 25
> objects is maintained.
> i would advise you to check for open connections....
> any errors during db call not handled (and explicitly calling
con.close() )
> would not release the connection to the pool
>
> if you are releasing all objects and are still running out cause of the
> heavy load... try specifying the pool size in connection string...
>
> --
> Regards,
>
> HD
>
> "Brian" <> wrote in message
> news:00d601c3d7ba$8bef23a0$...
> > Hello,
> >
> > I'm having a recurring error whenever I try to debug a
> > asp.net web page is retrieving data from a SQL server.
> > The error msg is:
> >
> > "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."
> >
> > Any ideas?
> >
>
>