Hi all,

I have DNN 4.4.1 installed. When I try to run a slightly complex operation more than a few times in a row |(say, in a loop), I get the following exception:

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.

When I look at the sql management studio activity monitor, I see about 150 connection with '.Net sqlClient data provider' application, and 'sleeping' status.

I have the same site installed on another machine, and everything works ok on it. So I'm guessing this is a local configuration problem..

Any Ideas? Thanks in advance " border=0>

Thanks for your rapid reply.

I'm using an SqlDAtaProvider class that calls sqlHelper 's  ExecuteReader function, that recieves a connection string an sp name and the sp parameters. I don't have a reference to the connection itself (Do I?), I'm not the one opening and closing it..

Ok, I will give it a try, thanks " border=0> 
(Although this still doesn't explain why its working on the other machine..)