iAnywhere.com - Using ODBC data sources on UNIX

Using ODBC data sources on UNIX

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 protocol options are added as part of the CommLinks (LINKS) parameter.

For a complete list of network protocol options, see Network protocol options.

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.

Caution You should not add simple encryption to the .odbc.ini system information file with the File Hiding utility (dbfhide) on UNIX unless you will only be using Adaptive Server Anywhere data sources. If you plan to use other data sources (for example, for MobiLink synchronization), then obfuscating the contents of the .odbc.ini file may prevent other drivers from functioning properly.

File location

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