Hmm... let me try to rephrase it, disregarding the code sample from before.
I trap the error and post a message to the main form. How can I attempt to
reconnect. The connection status of the TIB_Connection remains as
csConnected after the error. If I do Connect(), nothing happens because it
thinks it's still connected. If I do Disconnect(), I get another error and
the connection status remains csConnected. How can I make the
TIB_Connection component realize that it is not connected and force it to
try to reconnect?

> -----Original Message-----
> From: Jason Wharton [mailto:jwharton@...]
> Sent: Monday, June 11, 2001 11:45 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Disconnect Troubles
>
>
> This looks to me like you could be asking for an infinit loop.
>
> It generally isn't a good idea to perform actually connect and disconnect
> operations in an error handler. it is better to set some flags
> and then have
> the operations be performed in some independent fashion.
>
> For example, you would flash a message to the user that the connection has
> been lost and what they should do. Then, after the exception is
> handled they
> would go and do whatever it was they needed to.
>
> HTH,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Paul Irwin" <paul@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Monday, June 11, 2001 11:34 AM
> Subject: [IBO] Disconnect Troubles
>
>
> > I'm trying to handle the situation where I loose a connection to the
> > database. In the OnError event of the TIB_Connection I have
> the following
> > code:
> >
> > if (ERRCODE == 335544721 && IB_Con->ConnectionStatus !=
> csDisconnectPending)
> > {
> > IB_Con->Disconnect();
> > IB_Con->Connect();
> > }
> >
> > I realize there needs to be more code to handle if it cannot connect
> > again... but this is just some test code. The problem is that
> Disconnect
> > generates another error and the connectionstatus gets reset to
> connected.
> >
> > How or what is the best way to handle this. I want to prompt the user
> with
> > a message that the connection has been lost and allow them to attempt to
> > reconnect.
> >
> > Thanks,
> >
> > Paul
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>