ADO reconnect after disconnect

From: john smith (jblack004_at_hotmail.com)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 16:35:48 +0200

Hi,
If I set an ADOConnection to keep the connection open during queries, I have
a problem reconnecting should I be disconnected due to network failure.
Everytime I try to reconnect after being disconnected the ADOconnection
reports it has connected even with the network cable unplugged. I also cant
close the connection after being disconnected.

At the moment the only way around seems to be to destroy the ADO components
and recreate the tables and datasets and then simply start the connection
from the beginning. I am able to detect when I am disconnected.

Thanks for any help,
S.

Relevant Pages

  • Re: module
    ... Dim adoConnection As ADODB.connection ... I don't understand why connection is not written Connection - that should be automatic. ... Copy that into google, including quotes. ...
    (microsoft.public.vb.general.discussion)
  • ADO Connection Failure
    ... Connection Failure error message. ... ADOConnection Status is still "Connected" erroneously. ... ADOConnection Level? ... without Closing all of the active Queries using that connection? ...
    (borland.public.delphi.database.ado)
  • Re: How to be notified if PBX link goes down
    ... Symposium server which is connected to PBX. ... >> I disconnected network cable between Nortel TAPI server and Symposium ... >> How do I register for network failure notification? ... > This function returns TRUE if connection is available or FALSE if not. ...
    (microsoft.public.win32.programmer.tapi)
  • Re: ADOConnection fail after a while in TThread
    ... I, as Martin, do not think it is wise to use so much of objects (both ADO and thread), Nevertheless you might increase the socket count etc. ... If you do not use Transactions and have only one Query per Connection you even do not need the Connection. ... The simpliest the best:) Solve the problem with "not permanent" connection to your stores. ... One strange thing is that I have a ADOConnection in the main thread as well. ...
    (borland.public.delphi.database.ado)
  • ADOConnection - odd problem solved but why?
    ... I have a form with an ADOconnection and two tables. ... Set to True at design time, ... Maybe an application cannot handle more than one ADO connection at once ...
    (alt.comp.lang.borland-delphi)