Rob,

I'd like to see why the initial call to Disconnect resulted in an error. It
is my intent to allow a smoothe disconnect so that you can reconnect without
hassle.

I have provided the method ForceDisconnect that you might want to use
instead of Disconnect.

People who have applications that are sensitive to lost connections tend to
use a briefcase model rather than a direct connection model. IBO isn't as
strong as other competing products whne it comes to providing a brief case
approach to handling client data.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: Tuesday, December 3, 2013 1:03 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] How to best handle network loss / changes

Hi

If I open a DB connection while logged into a VPN and then close my VPN
connection my DB connection breaks. This also happens some times when
plugging in / unplugging a network cable or loosing a Wifi connection
or logging into a new Wifi connection. One user even reports problems
while hibernating a laptop. It is easiest for me to replicate this by
using a VPN however :)

I am not blaming IBO or FB for that matter, but I would like to know how
best to deal with this situation?

Currently when I turn off the VPN the IBODatabase stays showing as
connected and there is no error until it tries to read further data
through the connection. At this point it gives a 'ISC 335544726 error
reading data from the connection' error if I try and get further data
from an open query or 'ISC 335544721 Unable to complete network request
to host "TAU"' if I try and open a new query. TAU is my machine name,
the app and DB are running on my PC and the connection is via TCP/IP
with the IBODatabase.Server property set to TAU.

If I try and close the connection with 'disconnect' I also get 'ISC
335544721 Unable to complete network request to host "TAU"' and the
connection is left open. A second attempt to close will work and I can
then reopen the connection and proceed ok. I am guessing that the DB
component looks up the IP address for the computer name and that when
this changes it doesn't re look it up! I have code that detects an IP
change an reconnects other (non DB) TCP connections in my app, it would
be great if I could do similar with IBO and FB.

Any suggestions ???

Thanks
Rob



------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgradeYahoo
Groups Links