connection pool weirdness

  • Thread starter Thread starter mrrrk
  • Start date Start date
M

mrrrk

Hi

I'm using a data reader and Microsoft's 'data access application block'
SqlHelper class. CommandBehaviour.CloseConnection is being used so
theoretically the connection should close when closing the reader.

However I'm getting "timeout period elapsed prior to obtaining a connection
from the pool"

The really weird thing is that SQL Server's Management > Current Activity >
Process Info say that things are peachy and Performance Monitor reports no
abnormal connection activity.

And yet time and time, after 90 or so reader executions the error occurs and
only goes after restarting IIS - only to return after another 90 or so
calls.

Using Framework 1.1 and SQL Server developer edition with SP3.

Any one got any ideas?
 
Hi,

Try not using SqlHelper and do the same to see if the error still happens.
Make sure you explictly close the connection or use CloseConnection
behaviour of datareader.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com
 
Back
Top