Easysoft ODBC-ODBC Bridge

I have no root access. How do I tell OOB/unixODBC to use odbc.ini and odbcinst.ini files not in /etc?

Article:
00635
Last Reviewed:
28th October 2008
Revision:
2

You do not need to be root to install the OOB client but certain parts of the installation of the unixODBC driver manager are not usually possible as a non-root user. Since unixODBC is built with the sysconfdir configuration option set to /etc, the odbcinst.ini file containing all the installed ODBC drivers resides in /etc by default (as does the odbc.ini containing SYSTEM data sources). You can tell unixODBC to look elsewhere for these files by setting and exporting the ODBCSYSINI environment variable to point to another directory you have write access to and creating the odbc.ini and odbcinst.ini files there instead.

e.g.
Say you have installed OOB and unixODBC in your home account. Create a etc directory in your home account, create odbcinst.ini and odbc.ini files as below and set/export ODBCSYSINI.

cd $HOME
mkdir etc
cd etc
echo "[OOB]" > odbcinst.ini
echo "Description = Easysoft ODBC-ODBC Bridge" >> odbcinst.ini
echo "Driver = $HOME/easysoft/oob/client/libesoobclient.so" >> odbcinst.ini
echo "Setup = $HOME/oob/client/libesoobsetup.so >> odbcinst.ini
echo "FileUsage = 1" >> odbcinst.ini
> odbc.ini
ODBCSYSINI=$HOME/etc
export ODBCSYSINI

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.