ASA Database Administration Guide
Connecting to a Database
Working with ODBC data sources
On UNIX operating systems, ODBC data sources are held in a file named .odbc.ini. A sample file looks like this:
[My Data Source] ENG=myserver CommLinks=tcpip(Host=hostname) uid=DBA pwd=SQL
You can type any connection parameter in the .odbc.ini file.
For a complete list or connection parameters, see Connection parameters.
Network communications parameters are added as part of the CommLinks (LINKS) parameter.
For a complete list of network communications parameters, see Network communications parameters.
You can create and manage ODBC data sources on UNIX using the dbdsn utility.
For more information, see Creating an ODBC data source, and The Data Source utility.
The database server looks for the .odbc.ini file in the following locations:
ODBCINI environment variable
ODBCHOME and HOME environment variables
The user's home directory
The path