Problem with ClearPool/closing connection
598829Sep 19 2007 — edited Jan 23 2008I am using odpnet 10.2.0.1.0 with AspNet 1.1 and I'm designing an application where evry users should have one dedicated connection (one connection string per user).
I need to close the connection of the user as soon as he quit the application and using the following code does not working :
OracleConnection conn = new OracleConnection(strConnectionString);
// Open the connection
conn.Open();
// Clears the connection pool associated with connection 'conn'
OracleConnection.ClearPool (conn);
// cleanup
conn.Close();
conn.Dispose();
I use the following parameters for the connection string of each user :
- name="Data Source" value="TNSVALUE"
- name="Password" value="UserPwd"
- name="User Id" value="UserName"
- Incr Pool Size value="1"
- Decr Pool Size value="1"
- Min Pool Size value="0"
How can I do this?