how to find the active connection string

[coolminded]

i have two databases for a single software in two different servers. i want to connect to the active server. if one server is down then it should automatically connect to another server. how to find out which one is active which is not ?
i have used postgres database and vb6.

[debasisdas]

Try to open the 1st database, if it is not accessible try to open the 2nd database.

[coolminded]

thank you debasisdas for your answer. but how to know that the database is inaccessible. because it will show the error message with "connection error" when the database is not accessible.
thank you

[QVeen72]

Hi,

Use Error Handler... First Open Conn to First server, If it opens without error, Exit Sub... OR Else try to Open Conn to second server..

Regards
Veena