Problem with connection pool

[DaM]

Hi guys,

I'm having this problem with my ASP.Net application:

I was testing the whole site, and it seem to work fine. Fast and
stable, but suddenly it stopped working and this error occurred:

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

What could be the cause? Every time I use a dataReader I'm pretty sure
I'm closing it.

Thanks in advance,
Dam

 

[Guest]

Hi,

Seems all connections in the pool are in use. You can control the number of
connections in the pool changing connection string. For MSSQL, use mix pool
size= and max pool size=
Visit
http://msdn.microsoft.com/library/d...nectionpoolingforsqlservernetdataprovider.asp
for more info. Also make sure you're closing reader/connection as soon as
the data has been populated/retreived.

 

[Karl Seguin]

Make sure you are closing both your connection and your datareader.

Make sure you are doing this in the Finally block

run sp_who in SQL Server to see who's connected

Check out:
http://www.15seconds.com/issue/040830.htm

for more ideas...

Karl

 

[Guest]

Sorry, not "mix pool size" but "max pool size"

 

[Kevin Spencer]

Hi Dam,

First of all, "pretty sure" is never sure enough! But let's assume for a
moment that you ARE closing all of your DataReaders.

There are a limited number of database connections available in any
Connection Pool. These Connections are created as needed, until the Maximum
Pool Size is reached. There is one Connection Pool created for each unique
Connection String used. When a database operation is requested, the
Connection String used is checked against the available Connection Pools. If
an existing Connection is available, it is re-used. If there are no
Connections available, the request is queued until either a Connection is
released, or the Timeout period expires.

A Connection is released not by closing a DataReader only, but by closing a
Connection object. Closing a DataReader releases the Connection object from
the DataReader, but does not close it. A Connection is released when you
call Close or Dispose on the Connection object.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

 

[Guest]

You can always use ExecuteReader(CommandBehaviour.Close) to close connection
automatically when calling IdbDataReader.Close().