- Download your driver manager of choice from their official website.Typical driver managers used on Unix are iODBC or unixODBC.iODBC is the choice made by Apple for their Mac Operating System, and unixODBC is a popular choice on Unix systems.Download your driver manager from the following websites:
- Install your driver manager.Install the driver manager with 32-bit and/or 64-bit libraries, depending on the requirements. See the instructions published by the appropriate driver manager provider/vendor.When installing unixODBC, the standard procedure is to execute:
> ./configure > make > sudo make install
The unixODBC driver manager will look for the odbcinst.ini file in the following locations (in order):
/etc/$ODBCINSTINI # If the environment variable ODBCINSTINI is defined. $HOME/.odbcinst.ini /etc/odbcinst.ini
The '/etc ' can be changed to some other directory of your choice during installation by executing:
> ./configure --sysconfdir=<my_dir>
If sysconfdir is not specified, the default directory is /etc. If it is, then the order of searching for odbcinst.ini is:
[sysconfdir]/$ODBCINSTINI # If the environment variable ODBCINSTINI is defined. $HOME/.odbcinst.ini [sysconfdir]/odbcinst.ini
For example, if the sysconfdir is /etc/unixODBC and your preferred odbcinst.ini file is /home/smith/proj/odbcinst.ini, then you will need to export the environment variable:
> export ODBCINISTINI=../../home/smith/proj/odbcinst.ini