When you use the iODBC ODBC Administrator tool, the odbcinst.ini and the odbc.ini files are typically located in the /Library/ODBC directory if the driver or data source was installed system-visible. If the driver or data source was installed to be user-visible, the odbcinst.ini and the odbc.ini files are in the $HOME/Library/ODBC directory.
At runtime, the iODBC Driver Manager searches for DSN information in $HOME/Library/ODBC/odbc.ini. If your DSN information is in /Library/ODBC/odbc.ini or in any other location, you need to set an environment variable called ODBCINI to the path to the odbc.ini file. For example:
setenv ODBCINI full pathname to the odbc.ini file
