ASP.NET Discussion - System.Data.OracleClient data pooling

Print Page | Close Window

System.Data.OracleClient data pooling

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3786
Printed Date: 28 March 2026 at 4:29pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: System.Data.OracleClient data pooling

Posted By: CountAnton
Subject: System.Data.OracleClient data pooling
Date Posted: 24 June 2003 at 9:13am

Hmm, I seem to have a connection pooling problem.

System.Data.OracleClient is supposed to have connection pooling built in. The idea is that if you use exactly the same connection string, it will reuse a connection from the pool. However in practise we seem to end up with loads of duplicate sessions, all inactive, sitting on the database. This web application isn't even accessible outside our development office, but already we are running out of sessions.

I've searched long and hard for a solution, but so far have turned up nothing. I thought it was time to ask if anyone else has encountered this problem? And if so, did you solve it and how?

-------------
Anton Channing
http://www.kiamagic.com

Replies:

Posted By: CountAnton
Date Posted: 01 July 2003 at 4:59am

Ah, looks like this might be a known bug with the .net Oracle dataprovider when used in ASP.Net

A fix is available but is still in testing, so is only available to those experiencing this specific problem...

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b330126 - http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b330126

-------------
Anton Channing
http://www.kiamagic.com