🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #709

Re: ADO Connection Time Out / Dropped

#709
From: Viatcheslav V. Vassiliev
Date: Thu, 21 Jul 2005 20:00
41 lines
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-mail
References: <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