ADO Connection Time Out / Dropped

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

Article #707

Back to borland.public.cppbuilder.database.ado Previous Next

#707

From: Heinz Ketchup
Date: Thu, 21 Jul 2005 15:04

17 lines
1749 bytes

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: <42dfb971$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsread.com!newsprint.newsread.com!38.119.100.83.MISMATCH!news-out.nntp.be!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,db328de64be2393b,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Heinz Ketchup" <heinz_like_the_ketchup@h0tmail.n0spam.c0m.n0spam>
Sender: "Heinz Ketchup" <heinz_like_the_ketchup@h0tmail.n0spam.c0m.n0spam>
Reply-To: "Heinz Ketchup" <heinz_like_the_ketchup@h0tmail.n0spam.c0m.n0spam>
Subject: ADO Connection Time Out / Dropped
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 146.131.120.2     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <42dfb971$1@newsgroups.borland.com>
Date: 21 Jul 2005 08:04:17 -0700
X-Trace: newsgroups.borland.com 1121958257 207.105.83.66 (21 Jul 2005 08:04:17 -0700)
Lines: 20
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsread.com!newsprint.newsread.com!38.119.100.83.MISMATCH!news-out.nntp.be!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail