Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with ClearPool/closing connection

598829Sep 19 2007 — edited Jan 23 2008
I 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2008
Added on Sep 19 2007
8 comments
4,142 views