Closing a connection which is in Session state and the connection is still open in Enterprise Manager
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"]
mySqlConnection.Close();
mySqlConnection.Dispose();
Session["mySqlConnection"]
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 ?
the problem is that when i want to close the connection :
SqlConnection mySqlConnection = (SqlConnection) Session["mySqlConnection"]
mySqlConnection.Close();
mySqlConnection.Dispose();
Session["mySqlConnection"]
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i changed it, now i don't see the connections in Enterprise Manager since it is closed just after executing commands.
thank you =)
thank you =)
no problem. Im glad that I could help.
ASKER