setup up an ODBC connection for mirroring with SQL Server Driver

Posted on 2009-02-11
Last Modified: 2012-05-06

I am setting up a ODBC connection using SQL Server driver (not native client).

I have an option in this setup which is greyed out relating to mirroring which I would like enabled

Use The Failover SQL Server If The Primary SQL Server Is Not AvailableIf the primary server becomes unavailable, the driver attempts to reconnect to the primary SQL Server; failing that, it attempts to connect to the failover server. The failover server must be defined at the SQL Server.

I have made my mirror database the default. How can I define the failover server at SQL server?
Question by:david_32
    LVL 42

    Expert Comment

    That means you need to first have a primary database and a mirror database configured to SQL server.  Then point the ODBC datasource to the primary.  If the option is set, the ODBC driver will attempt to failover to the mirror if the primary becomes unavailable.  

    Author Comment

    That is all done (i.e. I have a primary and mirror). The problem is the option is greyed out using SQL server driver.
    LVL 42

    Expert Comment

    >I have made my mirror database the default.

    What do you mean?

    Accepted Solution

    Actually I have made the principal database the default database to connect to in the ODBC configuration.
    LVL 42

    Expert Comment

    I have no further suggestions.  Any one else?

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now