ADO.NET Connection Pooling Explained
Subject:   Oracle - how to validate connections
Date:   2006-03-16 10:07:08
From:   solutionsahead
Response to: Oracle - how to validate connections

Hi Akeh!

I have a .Net - Oracle connection problem. Can you help?

I have developed a E-business web application in Visual Studio.NET1.0 with ASP.NET, C# and Oracle9i as the database. The application is hosted on a windows Terminal Server with 2 GB RAM and 80 GB HDD resource.

There is a lot of inactive sessions. The connections don't seem to be released from the pool whether I call dispose(), close(), or both, and this keeps building-up as users connect to the portal. We have used .NET 1.1 frame work with service pack 1 on the server. Can someone provide me with a solution recommendation asap?

Thanks in anticipation?