Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

Easysoft ODBC-ODBC Bridge

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

Article:
00635
Last Reviewed:
12th January 2024
Revision:
2

You do not need to be root to install the Easysoft ODBC-ODBC Bridge client. However, certain parts of the unixODBC Driver Manager installation 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. (As does the odbc.ini file, containing SYSTEM data sources.) You can tell unixODBC to look elsewhere for these files by setting and exporting the ODBCSYSINI environment variable. Point ODBCSYSINI to another directory you have write access to and create the odbc.ini and odbcinst.ini files there instead.

E.g. say you have installed ODBC-ODBC Bridge and unixODBC in your home account. Create an 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 "[ODBC-ODBC Bridge]" > 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)