System.Data.OracleClient problem: Not closing open connection

[ajaykrishna]

Hi

Could any one tell me what is the latest version of System.Data.OracleClient? Currently I'm using version 1.0.1012.0 in my project which is giving problem of not closing connection eventough I'm issuing connection Close() statement.I am trying to connect Oracle 8i from ASP.NET framwork 1.1 in my application. Initially I tried to put Connection Lifetime property to 60 seconds, when the application using Pooling concept. But this did not solve my problem and I was getting error like "ORA-00020: maximum number of processes (100) exceeded " when I am reaching 100 sessions, because the connection is not getting closed.Later, I set Connection Pooling to false. I did this after getting feedback from internet newsgroup

Can any one help me to get around this problem??? I would be greatful to get answer for this as I need to solve this ASAP

Thanks in Advance
Ajay

 

[Miha Markic [MVP C#]]

Hi,

See:
FIX: Connection Leak with .NET Data Provider for Oracle in ASP.NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;330126&Product=NETFrame
(though the bug seems to appear in 1.0sp2)
--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Hi,

Could any one tell me what is the latest version of

System.Data.OracleClient? Currently I'm using version 1.0.1012.0 in my
project which is giving problem of not closing connection eventough I'm
issuing connection Close() statement.I am trying to connect Oracle 8i from
ASP.NET framwork 1.1 in my application. Initially I tried to put Connection
Lifetime property to 60 seconds, when the application using Pooling concept.
But this did not solve my problem and I was getting error like "ORA-00020:
maximum number of processes (100) exceeded " when I am reaching 100
sessions, because the connection is not getting closed.Later, I set
Connection Pooling to false. I did this after getting feedback from internet
newsgroup.

Can any one help me to get around this problem??? I would be greatful to

get answer for this as I need to solve this ASAP.

Thanks in Advance.
Ajay

Community Website: http://www.dotnetjunkies.com/newsgroups/

 

[Rob Panosh]

Ajay,

I had a problem simuliar to this within a loop and I set my connection
object to nothing after closeing it and it resolved my problem. I think
when the connection object is garbage collected it will be relased in
Oracle.

Regards,
Rob

Hi,

Could any one tell me what is the latest version of

System.Data.OracleClient? Currently I'm using version 1.0.1012.0 in my
project which is giving problem of not closing connection eventough I'm
issuing connection Close() statement.I am trying to connect Oracle 8i from
ASP.NET framwork 1.1 in my application. Initially I tried to put Connection
Lifetime property to 60 seconds, when the application using Pooling concept.
But this did not solve my problem and I was getting error like "ORA-00020:
maximum number of processes (100) exceeded " when I am reaching 100
sessions, because the connection is not getting closed.Later, I set
Connection Pooling to false. I did this after getting feedback from internet
newsgroup.

Can any one help me to get around this problem??? I would be greatful to

get answer for this as I need to solve this ASAP.

Thanks in Advance.
Ajay

Community Website: http://www.dotnetjunkies.com/newsgroups/

 

[Kevin Yu]

yes, that's an old problem from version 1.0, I think they fixed it in
framework 1.1.


Kevin

Hi,

Could any one tell me what is the latest version of

System.Data.OracleClient? Currently I'm using version 1.0.1012.0 in my
project which is giving problem of not closing connection eventough I'm
issuing connection Close() statement.I am trying to connect Oracle 8i from
ASP.NET framwork 1.1 in my application. Initially I tried to put Connection
Lifetime property to 60 seconds, when the application using Pooling concept.
But this did not solve my problem and I was getting error like "ORA-00020:
maximum number of processes (100) exceeded " when I am reaching 100
sessions, because the connection is not getting closed.Later, I set
Connection Pooling to false. I did this after getting feedback from internet
newsgroup.

Can any one help me to get around this problem??? I would be greatful to

get answer for this as I need to solve this ASAP.

Thanks in Advance.
Ajay

Community Website: http://www.dotnetjunkies.com/newsgroups/