Page 1 of 1

Automatic Reconnect

Posted: Fri 05 Dec 2008 14:18
by andi_d
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

Posted: Tue 09 Dec 2008 08:39
by Dimon
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.