Devart Forums

Hi,

I have developed an 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?

SRK

Please use OracleConnection.ClearAllPools() or OracleConnection.ClearPool().
Or use OracleConnection="Pooling=false;......" for disabling pooling

We have tried that as well...

SRK

What value of Pooling parameter do you use in your application? It is "true", "false" or blank?
Please note that ClearAllPools and ClearPool clears pools during 40 seconds. How did you determine
that there are opened connections to Oracle server?