Post reply

setup up an ODBC connection for mirroring with SQL Server Driver

  • February 11, 2009 at 11:32 pm

    #201067

    Hi,

    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 Available—If 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?

  • March 26, 2009 at 9:16 am

    #966760

    I'm confused.

    If you set up connections to SQL from a client with ODBC, you don't have failover. You need SNAC (native client).

    From the server, for mirroring, the failover depends on what connection mode you set. Sync, async, etc. Where are you seeing the option grayed out? Is the mirror up and running?

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply