DB Mirroring / Auto-Failover, but ODBC?
Posted on 2010-08-18
I think I have a problem.
I'm all excited about finally getting auto-failover in place for some of our databases, using High Safety configuration and mirroring.
For client apps, I know we can edit the connection strings to identify the failover server.
But...it just hit me that some of our backbone (third-party) applications use ODBC DSNs to identify our primary server.
Crap! I really want to use this configuration, and not a Windows Server cluster or anything like that.
What are my options? I cannot convert this app to use ODBC. And I cannot convert it to allow OLEDB connections.
Thanks for any insight on this.