connection pool weirdness

[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?

 

[Miha Markic [MVP C#]]

Hi,

Are you using w2k?

 

[mrrrk]

Hi,

Are you using w2k?

No, XP Professional

 

[Miha Markic [MVP C#]]

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