Subject | Re: [IBO] How to best handle network loss / changes |
---|---|
Author | Chuck Belanger |
Post date | 2013-12-03T23:43:27Z |
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
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com
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