skip to main content
Using the Driver : Configuring and Connecting to Data Sources : Configuring the Product on macOS : Environment Variables : ODBCINST

Try DataDirect Drivers Now
The installer program installs in the /Library/ODBC directory a default file, named odbcinst.ini, for use with DSN-less connections. However, if the user does not have access to the system library, the installer falls back to the /Users/user_name/Library/ODBC directory. See "DSN-less Connections" for an explanation of the odbcinst.ini file. The system administrator can choose to rename the file or move it to another location. In either scenario, the environment variable ODBCINST must be set to point to the fully qualified path name of the odbcinst.ini file.
For example, to point to the location of the file for an installation on /Users/john_smith/Library/myapp in the Terminal, you would set this variable as follows:
setenv ODBCINST /Users/john_smith/Library/myapp/odbcinst.ini
As an alternative, you can choose to make the odbcinst.ini file a hidden file and not set the ODBCINST variable. In this case, you would need to rename the file to .odbcinst.ini (to make it a hidden file) and move it to the user's home directory, for example /Users/john_smith/.
The Driver Manager searches for the location of the odbcinst.ini file as follows:
1. The Driver Manager checks the ODBCINST variable
2. The Driver Manager checks the /Library/ODBC and /Users/user_name/Library/ODBC directories for .odbcinst.ini
If the driver does not locate the odbcinst.ini file, it returns an error.