Detect connection loss with ADO

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

Article #4661

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

#4661

From: dave
Date: Thu, 25 Oct 2001 12:47

10 lines
1050 bytes

Hi,


Is there a bullet proof way to check if the conection is still alive.
The 'STATE' property never changes when the connection is lost.

using bcb5 ent. and  adoexpress.

thx,
dave

Technical Details

Message-ID: <3bd809fc_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d87ecfbec8b8758e,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-10-25 05:55:48 PST
From: "dave" <ddegreef@kpmg.be>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Detect connection loss with ADO 
Date: Thu, 25 Oct 2001 14:47:54 +0200
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 194.119.248.66
Message-ID: <3bd809fc_1@dnews>
X-Trace: dnews 1004014076 194.119.248.66 (25 Oct 2001 05:47:56 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews