UNIX

If you are linking to the unixODBC Driver Manager, edit the datasource template and reinstall the datasource using the unixODBC command line tool:

#  odbcinst -i -s -f dsn template file

where dsn template file is the complete path to the Adaptive Server ODBC datasource template file.

If you are directly linking to the Adaptive Server ODBC Driver or Sybase iAnywhere ODBC Driver Manager, modify the odbc.ini file.

This is an example of the odbc.ini datasource template file:

[sampledsn]
Driver=Adaptive Server Enterprise
Server=sampleserver
Port=4100
UserID=sa
Password=
Database=pubs2
HASession=1
SecondaryHost=failoverserver
SecondaryPort=5000