Subject Re: [IBO] How to best handle network loss / changes
Author Chuck Belanger
Hi, Jason:

Could you point me to a link or two or even something I can google
regarding:
"briefcase model for handling client data?" What is this? What does that
mean?

Thanks,

Chuck Belanger
> 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
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>


---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com