Re: ado.connected:=false fails

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 12/22/04

  • Next message: Marc Scheuner: "Re: Use query or stored procedure" 
    Date: Tue, 21 Dec 2004 18:40:15 -0600

    >My network fails, and when i execute an ado (TAdoConnection) statement i get
    >an error from the odbc driver that connection has been lost.
    >Ado.connected returns true at this time. But when i try to reconnect by
    >first setting ado.connected:=false it fails with an error from the odbc
    >driver and ado.connected is still true. I cant find a way to reconnect even
    >if i free the adoConnection object it fails to free. Is there a solution to
    >this?

    Are you really freeing the ConnectionObject?
    You code should look like this.

    ADOConnection1.Connected := false;
    ADOConnection1.ConnectionObject := Nil; 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: Marc Scheuner: "Re: Use query or stored procedure"

    Relevant Pages

    • Disconnection cant reconnect
      ... The remote desktop connection is a dial-up VPN connection both systems are ... When the connection is lost can't reconnect and the ... client machine is left in a state of can't login when trying to restart in ...
      (microsoft.public.windowsxp.work_remotely)
    • ado.connected:=false fails
      ... My network fails, and when i execute an ado statement i get ... an error from the odbc driver that connection has been lost. ... I cant find a way to reconnect even ...
      (borland.public.delphi.database.ado)
    • Re: $100 reward for socket disconnection help
      ... > I'm running Java 1.4.1 as an applet on the client side, under Windows 98, ... > with a DSL connection through a Linksys Wireless-B Router. ... > disconnects at the same time my application does ("AOL Instant Messenger ... > still trying to reconnect, IM is always able to immediately reconnect, and ...
      (comp.lang.java.programmer)
    • Re: restarting mobile broadband
      ... I'm a newbie to NetworkManager and have a few ... connection drops from time to time and doesn't ... But is doesn't reconnect automatically ... and a file called rx_bytes which may or may not run boot to boot rather than ...
      (Fedora)
    • Re: MS Access looks for .mdb rather than Progress schema
      ... I've played around with these settings, ... The settings for the Merant ODBC driver for ... If you want to specify an ODBC or ISAM database, ... when I use that connection I get that database: ...
      (microsoft.public.access.modulesdaovba)