odbc64.ini File Example

To configure the 64-bit ODBC Client installed on a Solaris machine to use connection failover in conjunction with some of its optional features in your odbc.ini file, you could set the following connection string attributes:

[ODBC Data Sources]
AccountingDB=DataDirect OpenAccess SDK 8.1
[AccountingDB]
Driver=path_of_installdir/lib64/ivoa26.so
Description=DataDirect OpenAccess SDK 8.1
Host=
Port=
UseLDAP=0
DistinguishedName=
AlternateServers=(Host=server1:Port=19986:ServerDataSource=SDSN1, Host=server2:Port=19986:ServerDataSource=SDSN2,Host=server3:Port=19986:ServerDataSource=SDSN3)
...
ConnectionRetryCount=4
ConnectionRetryDelay=5
...
LoadBalancing=1
...
ConnectionRetryCount=4  
ConnectionRetryDelay=5  
...  
LoadBalancing=1  
...

This odbc64.ini configuration tells the ODBC 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 (use load balancing).