HighTechTalks DotNet Forums  

System.Data.OracleClient problem: Not closing open connection

Dotnet Academic General Discussions microsoft.public.dotnet.academic


Discuss System.Data.OracleClient problem: Not closing open connection in the Dotnet Academic General Discussions forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
ajaykrishna
 
Posts: n/a

Default System.Data.OracleClient problem: Not closing open connection - 02-27-2004 , 02:30 AM






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 With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.