Hi Team,
With EDB, what is the best method to test if there is still a connection to the Database in local & remote modes and restoring the connection if the connection is lost?

Regards & TIA,
Ian

Ian


It depends on just what you want to do. As a starter have a look at the Session & Database component events.

Roy Lambert

Hi Roy,
Will do.  One of my Customers is in the Pacific islands and their 'technology' level isn't the greatest.  Still using Win XP wkstns.  Anyway, their network isn't as reliable as it could be and tends to drop out from time to time.
The objective is to test connectivity periodically and if lost, attempt to restore, transparent to the users.

Regards,
Ian

Ian


Once I dumped the wireless networking gear I bought as my first experiment at going wireless and went to NetGear equipment I haven't suffered from instability in my LANs so I don't know for certain.

The c/s server itself should (subject to settings) reconnect sessions that have disconnected, with the events there to help manage the process. Fileserver - I don't think there's much.

Ultimately there's only one way to test a network connection - use it. The number of questions I've seen splattered all around the internet basically asking "how do I know if I'm connected to the internet?" is enormous.

Here's one suggestion:

1. Create a thread
2. Pass the IP address of the server (C/S or F/S) as part of the thread creation
3. Ping the server

if the ping is returned then

4. In the thread query the information database - say SELECT * FROM Information.Tables. Use a try..except block

if OK then sleep, waitfor or somesuch then rinse and repeat

if the ping isn't returned or the query fails message the main thread and tell it to do something.



Roy Lambert

Hi Roy,
Yes, that's pretty much what I have worked out will be necessary.
Thanks for your input.
Regards,
Ian

Ian,

<< With EDB, what is the best method to test if there is still a connection to the Database in local & remote modes and restoring the connection if the connection is lost? >>

Read this technical article, it has all of the information that you need:

https://www.elevatesoft.com/articles?action=view&category=edb&article=connections_disconnections_reconnections

Tim Young
Elevate Software
www.elevatesoft.com