Oracle NET Maximum Connections reached

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aziz - 16 Aug 2004 14:33 GMT

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

Reply to this Message

Cowboy \(Gregory A. Beamer\) [MVP] - 16 Aug 2004 16:50 GMT

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.

Signature

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

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

> I am using Data.OracleClient.Dll version 1.0.1012.0 and closing the
> connections in code using .close
[quoted text clipped - 13 lines]
>
> Thank You

Reply to this Message

Joyjit Mukherjee - 17 Aug 2004 06:04 GMT

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

> I am using Data.OracleClient.Dll version 1.0.1012.0 and closing the
> connections in code using .close
[quoted text clipped - 13 lines]
>
> Thank You

Reply to this Message

Oracle NET Maximum Connections reached

Free Magazines