InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 04:46:53 GMT20http://www.sqlservercentral.com/Forums/Topic1420400-146-1.aspxAfter re-reading your original post, it looks like you may be using the correct client (As you mention you have the mirror instance set) As a troubleshooting test I would failover the server and see if you can create a connection to the mirror only - set it as the primary server, as if there were no mirroring. What king of authenitcation are you using NT or SQL? SQL users have to have the same SID on the principal and the mirror (otherwise they will be a db orphan when flipped to the mirror)Wed, 27 Feb 2013 11:21:23 GMTkrefiorhttp://www.sqlservercentral.com/Forums/Topic1420400-146-1.aspxIf you don't see the option for Failover in the ODBC driver you need to install a newer ODBC. If I remember right you need to have at least SQL server native client 10 to support failover. When you create the new data source, select the Native 10 (or higher) driver.You have to select a default database (of course) and then can select a mirror server. (this is on the second page of creating a new DSN)Wed, 27 Feb 2013 10:37:19 GMTkrefiorhttp://www.sqlservercentral.com/Forums/Topic1420400-146-1.aspxSQL Server Gurus any solution to mu question?Sun, 17 Feb 2013 23:27:56 GMTasir83http://www.sqlservercentral.com/Forums/Topic1420400-146-1.aspxHello,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.Thanks AsirFri, 15 Feb 2013 00:08:48 GMTasir83