Part 2: The 32-Bit/64-Bit Drivers : The SQL Server Legacy Wire Protocol Driver : Connection Option Descriptions : Alternate Servers

Alternate Servers
This information pertains to UNIX and Linux.
Attribute
AlternateServers
Purpose
A list of alternate database servers to which the driver tries to connect if the primary database server is unavailable. Specifying a value for this option enables connection failover for the driver. The value you specify must be in the form of a string that defines the physical location of each alternate server. All of the other required connection information for each alternate server is the same as what is defined for the primary server connection.
Valid Values
(Address=addressvalue[, . . .])
You must specify the network address of each alternate server.
Example
The following two Alternate Servers values define two alternate database servers for connection failover:
AlternateServers=(Address=MySQLServer\Instance1,
Address="255.125.1.11, 5002")
In this example, the network address of the last alternate contains commas. In this case, enclose the network address with double quotation marks as shown.
Notes
Default
None
GUI Tab
Failover tab

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.