Closing a connection which is in Session state and the connection is still open in Enterprise Manager
Posted on 2005-05-11
Hi, i've got a web application which creates and open a connection in the page load and then stores it in the session state.
the problem is that when i want to close the connection :
SqlConnection mySqlConnection = (SqlConnection) Session["mySqlConnection"];
Session["mySqlConnection"] = null;
it is still visible and open in Enterprise Manager
the real problem is that when there are a lot of activity on this application, all the connections stay opened and so the pool becomes full and noone can connect =/
what's the problem ?