Not sure if there is a component that does this automatically. But I have done exactly what you describe to several of my client/server modules to make them more robust. Checking for the validity of the connection, or handling the exception is where I detect the disconnect. I also use a thread to do the reconnect. It took some work to get it right, but once I did, it has behaved very nicely.

Eric Tishler
Software Architect
Resolute Partners, LLC
Phone: 203.271.1122
Fax: 203.271.1460
etishler@...

-----Original Message-----
From: Robert Martin [mailto:roberto@...]
Sent: Friday, June 11, 2004 3:03 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Remote server disconnect

Hi, All!

This is one of those "There must be an easier way!" things.

I am connected to a remote DB via a TIB_Connection. Every thing works
fine.

Now I pull my eithernet cable from the back of my computer, simulating a
remote
server reboot.

make a request and get an exception.
so far so good.

now I plug back in my eithernet connection and make another request. I
get another exception, and will keep getting them until I disconnect and
reconnect the database.

the only way around this that I can figure is to write an error handler
that fires off a thread that trys and retrys to reconnect the database
when an error of this type is encountered.

Am I missing a setting or component that will do this for me?

Thanks in advance
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 !





Yahoo! Groups Sponsor


ADVERTISEMENT
<http://rd.yahoo.com/SIG=129i8l8m6/M=298184.5022502.6152625.3001176/D=groups/S=1705007183:HM/EXP=1087067034/A=2164331/R=0/SIG=11eaelai9/*http://www.netflix.com/Default?mqso=60183351> click here

<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=:HM/A=2164331/rand=798235018>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

* To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com <mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service.


[Non-text portions of this message have been removed]