ODBC Connection to SQL Server Database

Question

I am opening a database connection to SQL Server 2008 mirrored principal database with ODBC from Java program. Can we specify mirrored node with connection string or use any other driver in Java in order to automatic failover of connection in case the database fails over.

Answer 1

0

I believe that the name is Failover_Partner, i.e.

Driver={SQL Server Native Client 10.0}; 
Server=YOUR_SERVER_NAME\INSTANCE_NAME;
Failover_Partner=YOUR_MIRROR_ADDRESS;
Database=DB_NAME;
/*creds go here or Trusted_Connection=yes is specified */

Oleg

answered Jan 26 '12 at 12:50 PM

Oleg
15.4k ● 1 ● 4 ● 24

(comments are locked)

ODBC Connection to SQL Server Database

Follow this question

Related Questions