skip to main content
Part 4: The Connect XE Drivers : The Sybase IQ Wire Protocol Driver : Connection Option Descriptions : Alternate Servers
  
Alternate Servers
Attribute
AlternateServers (ASRV)
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
({NetworkAddress=addressvalue | InterfacesFileServerName=sectionvalue}[, ...])
NetworkAddress and InterfacesFileServerName can be used in the same string.
Notes
*An alternate server address in IPv6 format must be enclosed in double quotation marks.
*You must specify the network address of each alternate database server or the section in the Interfaces file that contains the network connection information for the Sybase IQ database server you want to access (InterfacesFileServerName).
*The Alternate Servers option and the HA Failover Server Connection Information option are mutually exclusive.
Example
The following example Alternate Servers values define three alternate database servers for connection failover:
(InterfacesFileServerName=Accounting, NetworkAddress="255.125.1.11, 4200", NetworkAddress="SybaseIQ2, 4200")
In this example, the network address of the last two alternates contain commas. In this case, enclose the network address with double quotation marks as shown.
Default
None
GUI Tab
Failover tab