skip to main content
Installation and Configuration on UNIX and Linux Systems : Setting Environment Variables : ODBCINI

Try DataDirect Cloud Now


Setup installs in the product installation directory a default system information file, named odbc.ini. See Configuring an ODBC Data Source on UNIX and Linux Systems for an explanation of the odbc.ini file. The system administrator can choose to rename the file and/or move it to another location. In either case, the environment variable ODBCINI must be set to point to the fully qualified path name of the .ini file that you wish to use for data source configuration.
For example, to point to the location of the file for an installation on /opt/odbc in the C shell, you would set this variable as follows:
setenv ODBCINI /opt/odbc/odbc.ini
In the Bourne or Korn shell, you would set it as:
ODBCINI=/opt/odbc/odbc.ini;export ODBCINI
As an alternative, you can choose to make the odbc.ini file a hidden file and not set the ODBCINI variable. In this case, you would need to rename the file to .odbc.ini (to make it a hidden file) and move it to the user’s $HOME directory.
The driver searches for the location of the odbc.ini file as follows:
1. The driver checks the ODBCINI variable.
2. The driver checks $HOME for .odbc.ini.
If the driver does not locate the system information file, it returns an error.