We have recently started getting the following error message:

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.

This is on a connection.open command.

Our ISP is providing the web machine and has many customers on it so I can't
really tell if it's us or some other customer that is causing the problem.

They (the ISP) says there's nothing in the event log or the SQL log (but I
don't believe them, we can't get at them.)

Does anybody have any ideas what would be causing this.

The original web site was done by our ASP but then another company made some
changes. I'm not even sure which section of code this is part of. I'll find
out.

But if anybody can give me a direction, it would help greatly.


With that thought - if you don't close a connection on a page, does it get
closed and returned to the pool for you? If not - that seems like that would
be a culprit.

TIA - Jeff.

Show quote Hide quote I think it will be closed, when the GarbageCollector eventually cleans
up after you. Best is to close that connection as soon as you are done
with it (and wrap that in a try/finally, so you are *sure* it will be
closed, even if the command failed).

I don't know how that connectionpool is managed. One per machine, one
per application or somewhere inbetween (application pool)? This decides
whether other applications can "steal" your available connections.

Hans Kesting

IE's view source not showing what is actually being displayed
Duplicate custom controls
List files in a directory, modify name.
How to Store web pages to local disk using httpwebrequest
asp.net control to run in web page like just COM
Wierd Warnings: mailSettings modification results in many web.config messages
browser compat issue
Occurence of Char!
Why use disconnected datasets?
Referencing the data within a sqldatasource dataset