Oracle NET Maximum Connections reached

[Aziz]

I am using Data.OracleClient.Dll version 1.0.1012.0 and closing the
connections in code using .close

but i still get the "Maximum connections reached" message and the
oracle server shows idle inactive connections for aspnet

The connection string used is
"Data Source=DEV001.SRV01;password=test;user id=test;Max Pool
Size=10;Min Pool Size=10"

Should i drop the use of Microsoft .NET Oracle provide and use Oracle
Net Provider, or aparently this is a know problem and microsoft has a
hotfix but i don't know where to download this from ?

any help would be greatly appreciated

Thank You

 

[Cowboy \(Gregory A. Beamer\) [MVP]]

I have not had this problem with the MS .NET Oracle provider. Make sure you
are disposing all connections and you should be fine.

As for the second question, I would say yes. Moving to ODP.NET is a good
move regardless of whether you are having an issue with the MS .NET
Provider, as it is better tuned for Oracle than the MS implementation.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************

 

[Joyjit Mukherjee]

Hi,

The Max Pool size element must have a value greater than the Min Pool size
element so, set it accordingly. Also, set Pooling = true within the
Connection String to turn on Pooling explicitly. I hope that would work.

Regards
Joyjit