An odbc.ini File Example
- Last Updated: April 25, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
An odbc.ini File Example
To configure the 32-bit Sybase Wire Protocol driver 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:
Driver=ODBCHOME/lib/ivasexx.so
Description=DataDirect Sybase Wire Protocol driver
...
AlternateServers=(NetworkAddress=123.456.78.90,5000:Database=AccountingSybaseServer,
NetworkAddress=098.765.43.21,5000:Database=Accounting)
...
ConnectionRetryCount=4
ConnectionRetryDelay=5
...
LoadBalancing=0
...
FailoverMode=1
...
FailoverPreconnect=1
...
Specifically, this odbc.ini configuration tells the driver 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, to try the primary and alternate servers in sequential order (do not use load balancing), to attempt reconnecting on new and lost connections, and to establish a connection with the primary and alternate servers at the same time.