Connection Pooling

[nukie]

Hi

I've developed a ASP.Net system running on a MS SQL 2000 database. My db connection class doesn't seem to close connections to the database. I've manually killed and close all connection objects, but SQL keeps on adding processes to the current activities for concurrent users.

Can anyone please help me with this ?

 

[chiph]

As long as the connect string is identical, the ADO.NET library will lump your connections into a pool for quicker access later.

As to why your connections aren't being closed ... remember that .NET is a garbage-collected language, so even though you set the object to nothing, it's not actually disposed of until a GC cycle is run by the FCL. Look at implementing the IDispose interface in your classes.

Chip H.