• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 707
  • Last Modified:

setup up an ODBC connection for mirroring with SQL Server Driver

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 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?
0
david_32
Asked:
david_32
  • 3
  • 2
1 Solution
 
dqmqCommented:
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.  
0
 
david_32Author Commented:
That is all done (i.e. I have a primary and mirror). The problem is the option is greyed out using SQL server driver.
0
 
dqmqCommented:
>I have made my mirror database the default.

What do you mean?
0
 
david_32Author Commented:
Actually I have made the principal database the default database to connect to in the ODBC configuration.
0
 
dqmqCommented:
I have no further suggestions.  Any one else?
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now