Article View: borland.public.cppbuilder.database.ado
Article #709Re: ADO Connection Time Out / Dropped
From: Viatcheslav V. Vassiliev
Date: Thu, 21 Jul 2005 20:00
Date: Thu, 21 Jul 2005 20:00
41 lines
2494 bytes
2494 bytes
Server can drop connection if it is idle quite longtime. This can not be controlled from program. //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "Heinz Ketchup" <heinz_like_the_ketchup@h0tmail.n0spam.c0m.n0spam> �������/�������� � �������� ���������: news:42dfb971$1@newsgroups.borland.com... > > Hi Everyone, > > This is I think, a relatively simple question, although there are a few > clear cut answers on the web. I'm establishing a connection through > TADOConnection->Open() Method. > > Now I can perform Transactions, but after IDLING (15 minutes+, Reviewing > the Information, going for Coffee, etc...) for awhile; the connection is > dropped and an Exception is thrown when another Query is made after the > IDLING period. > > If the property Keep Connection = true, why is the connection dropping? Is > this a bug in ADO? > > I connect to 2 DB, Oracle 8.x and Sybase 7.x > Is this possibly a DB issue, where internally the thread is terminated? > > I'm just looking to solve my problem. > I'll try to catch the exception and do an Open Statement again to see if > that will be a temporary work around. > > Thanks Everyone, > Heinz > > >
Technical Details
Message-ID:
<42dffedc@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!meganewsservers.com!feeder2.on.meganewsservers.com!newshosting.com!nx02.iad01.newshosting.com!news-out.nntp.be!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<42dfb971$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,db328de64be2393b X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <42dfb971$1@newsgroups.borland.com> Subject: Re: ADO Connection Time Out / Dropped Date: Fri, 22 Jul 2005 00:00:29 +0400 Lines: 43 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-RFC2646: Format=Flowed; Original NNTP-Posting-Host: 85.93.138.132 Message-ID: <42dffedc@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1121976028 85.93.138.132 (21 Jul 2005 13:00:28 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!meganewsservers.com!feeder2.on.meganewsservers.com!newshosting.com!nx02.iad01.newshosting.com!news-out.nntp.be!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail