I am having a question on configuring mirror DB on ODBC. When a Principal DB goes down the mirror DB comes up & becomes the principal DB, this will be in the case of High safety with/without automatic failover.
However, I am intreseted to know, how can we make this work on ODBC. I have configured a SQL Server Native client & created the ODBC setup, mentioned the mirror instance name as well & using a SQL Authenticated login.
The moment i do a failover on the DB side, the connection on the application side breaks inspite of mentioning the mirror instance.
I am not able to understand how can i make this work so that when the DB is failed over, the application shouldn't break, just like clustering.