The following connection string configures the ADO Client connected to a Linux, UNIX, or Windows server to use connection failover in conjunction with all of its optional features—load balancing, connection retry, and connection retry delay.
Data Source=MyADODSN;User Id=test;Password=secret;Alternate Servers=(Host=server2:Port=19986:Server Data Source=SDSN2,Host=server3:Port=19986:Server Data Source=SDSN3);Connection Retry Count=4;Connection Retry Delay=5;Load Balancing=1
Specifically, if a successful connection is not established on the ADO Client’s first pass through the list of OpenAccess SDK Servers, this connection string configures the ADO Client to use two alternate servers as connection failover servers, to attempt to connect four additional times if the initial attempt fails, to wait five seconds between attempts, and to try the primary and alternate servers in a random order.
The additional connection information required for the alternate servers is specified in the OpenAccess SDK Server data source SDSN3.
