Connection is Sleeping ? What does it mean

[apexbs]

Hi ;

I have a website which is developed using ASP.NET 2003 and SQL Server 2000.

I am having a problem with Connection Pooling and try to make sure either each connection object is close and destry and I did and checked the whole website and closed and destroyed each and every connection , data readers, command objects.

If I go to Management of SQL Server Enterprise Manager and see the current process, there are hundereds of Processes which are in Sleeping Mode. Why those objects are still there even I closed and destroyed them. I am having Time Out Expired error which says there is no pool is available to connect. I using simple Connection String to connect SQL which contains four parameteres i.e. Server, Database, UserID, PW.

Thanks.

 

[chiph]

If you're coding in C#, be sure to use the using keyword to surround your Connection object. It will call .Dispose for you automatically.

Another thing you can look at (temporarily) is upping the number of connections in the pool. I don't remember the exact parameter name, but it goes on the connection string.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first