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


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.  

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


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

<div>
&gt;I have made my mirror database the default.<br />
<br />
What do you mean?
</div>


>I have made my mirror database the default.

What do you mean?

<div>
I have no further suggestions. &nbsp;Any one else?
</div>


I have no further suggestions.  Any one else?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am setting up a ODBC connection using SQL Server driver (not native client).<br />
<br />
I have an option in this setup which is greyed out relating to mirroring which I would like enabled<br />
<br />
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.<br />
<br />
<br />
I have made my mirror database the default. How can I define the failover server at SQL server?<br />

</div>
</div>


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?


setup up an ODBC connection for mirroring with SQL Server Driver

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.