ExamGuru IT/.Net Guru : System.Data.OracleClient Problem: Not closing open connection on microsoft.public.dotnet.framework.odbcnet

.NETGURU

System.Data.OracleClient Problem: Not closing open connection

Messages

Related Types

This message was discovered on microsoft.public.dotnet.framework.odbcnet.

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

---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/

Reply to this message...

Karl

Hello ajaykrishna,
I noticed that you haven't posted back about this issue. Did you figure the problem out? I'm having the same problem and it is quite annoying that this doesn't work.

~Karl

----- ajaykrishna wrote: -----

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

---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/

Reply to this message...

Rick W

Ajay,
Are you using the DataReader? If so, make sure you are setting the optional parameter for the ExecuteReader method of the Command object:
oDataReader = oCommand.ExecuteReader(CommandBehavior.CloseConnection);
If you do not do this, even though you close the DataReader, the connection stays open.

Good Luck!

Reply to this message...

System.Data.CommandBehavior

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification