Automatic Reconnect

andi_d · Post by **andi_d** » Fri 05 Dec 2008 14:18

Hi!

I'd like to enhance my source-code with a function that my database is reconnecting automaticly if connection to database got lost. (maybe if remote server is down).

Has anyone an idea how this can be done?

Thanks for helping!!!!

I'm usind SDAC 4.70.042 and SQL Server 2000

Andi

Dimon · Post by **Dimon** » Tue 09 Dec 2008 08:39

You can set the LocalFailover option to True.
You can find more detailed information about it in the "Working in an unstable network" topic of SDAC help.