To use failover on Mac OS X
Launch the iODBC Administrator from Applications | Utilities.
Select the data source you want to use and add three new keyword value pairs:
HASession=1 SecondaryHost=failoverserver SecondaryPort=5000