Set the $ODBCINI environment variable
Set the $ODBCINI environment variable to provide access to your DSN by system users
By default, HCL OneDB™ ODBC Driver uses configuration information found in the $HOME/.odbc.ini file. If you want to provide access to your DSN by system users, modify the path in the $ODBCINI environment variable to point to another configuration file that also contains the configuration information found in the $HOME/.odbc.ini file. Then change the configuration file permissions to allow read access for system users. Do not change the permissions to the $HOME/.odbc.ini file.
In
the following example, the configuration file name is myodbc.ini:
setenv ODBCINI /work/myodbc.ini