🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: ADO connection state

#4675
From: dave
Date: Mon, 29 Oct 2001 17:00
23 lines
1927 bytes
Hi Mark and the others,

Indeed if everything worked as written in the help files I would be a verry
verry happy man, now since I am still using BCB at work for our development
I am 'just' a happy man ;-))

Ok on the serious side now :

When the pc losses the network connection the ADOConnection remains
active/connected even we know it's not the case.
I tried against an Access db and against an AS/400, it's the later wich is
for me of interest since this is the real life DB of our customer.
The problem is that I use the ADO<-->ODBC (via MSDASQL provider) bridge to
connect to the AS/400 since their (read IBM client Access Express) OLE DB
(IBMDA400) provider seems to be working very badly with ADOExpress(huge
mermory leaks, freezing a kind of  big pc, seemed fine working straight with
the provider altough).

Anyone who has a bullet proof solution for this kind of problem ?
Also if anyone had success working with the IBM ole db provider please let
me know !?

Thanks again, david
Technical Details
Message-ID: <3bdd8b36_2@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
References: <3bd58f23_2@dnews> <3BDD474B.AF878476@temporaldoorway.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,9bf452d1cf4d7d0b
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-10-29 09:03:42 PST
From: "dave" <ddegreef@kpmg.be>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3bd58f23_2@dnews> <3BDD474B.AF878476@temporaldoorway.com>
Subject: Re: ADO connection state
Date: Mon, 29 Oct 2001 18:00:21 +0100
Lines: 28
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: <3bdd8b36_2@dnews>
X-Trace: dnews 1004374838 194.119.248.66 (29 Oct 2001 09:00:38 -0800)
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