J
J
jov2014-05-02 09:50:16
ODBC
jov, 2014-05-02 09:50:16

Change on the fly odbc connection string, is it possible?

There is a windows application that uses ms sql 2008 r2 for logging. When configuring, it is possible to specify only instance-name, user, password, database. The program uses mssql native client 10.0 to connect. Set up redundancy of mssql-servers through mirroring with a witness server. The problem is that I can't get to start writing logs to the backup database when the primary one crashes. That is, in fact, I need to somehow add "Failover Parther" to the set of connection options on the fly, bypassing the program. Is it possible? or are there any other options for providing redundancy at the driver level in the same way as it is done, for example, when configuring an ODBC DSN?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question