How do I install an Easysoft ODBC driver on a machine where I have no root access?
- Download the driver distribution from the Easysoft web site. Copy the distribution file to the home directory on the machine where you want to install the driver.
- On this machine, set the
EASYSOFT_ROOT
environment variable to point to:installation_path/easysoft
where
installation_path
is the directory under which you want to install the driver. All files are installed in aneasysoft
subdirectory of theinstallation_path
you specify. For example, if you want to install the driver under/home/myuser
, enter this command:export EASYSOFT_ROOT=/home/myuser/easysoft
- Create a directory where you want the unixODBC configuration files to be located. Set the
ODBCSYSINI
environment variable to point to this directory. For example:cd mkdir odbc export ODBCSYSINI=/home/myuser/odbc
The installation script creates an
odbcinst.ini
andodbc.ini
file in the directory you specify.odbcinst.ini
contains an entry for the Easysoft ODBC driver.odbc.ini
contains the ODBC data source created by the installation. - Set the environment variables needed by the Easysoft ODBC driver. For example:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$EASYSOFT_ROOT/lib:$EASYSOFT_ROOT/unixODBC/lib:$EASYSOFT_ROOT/sqlserver
Refer to the Easysoft ODBC driver documentation to find out which environment variables you need to set (
LD_LIBRARY_PATH
,LIBPATH
,LD_RUN_PATH
,SHLIB_PATH
, orORACLE_HOME
depending on the driver, platform, and linker). - Unpack the Easysoft ODBC driver distribution. For example:
tar -xvf odbc-sqlserver-2.2.0-sunos-sparc.tar
-
cd
to the directory created by unpacking the distribution. Run the installation. For example:cd odbc-sqlserver-2.2.0-sunos-sparc ./install
- When prompted, continue with the installation as a non-root user. For example:
Parts of this installation requires the installer to be the root user and you do not appear to be root. **WARNING** You can still install the Easysoft ODBC-SQL Server Driver but the installation will be unable to update the dynamic linker search paths or install the driver under the unixODBC Driver Manager (the latter is not necessary). You may complete these processes manually by consulting the INSTALL file in the current directory. Do you want to continue with the installation? (y/n) [n]: y
- Specify the directory under which you want the driver to be installed. For example:
Enter a base install directory (q=quit) [ /usr/local ]: /home/myuser
Note Don't append
/easysoft
to the directory you specify. The installation automatically creates theeasysoft
subdirectory. So, if, before running the installation, you setEASYSOFT_ROOT
to/home/myuser/easysoft
, you would specify/home/myuser
not/home/myuser/easysoft
. - Make sure you install the unixODBC Driver Manager that's included with the Easysoft ODBC driver:
Do you want to use your installed unixODBC DM in preference to the version included with this distribution? (y/n [n]) : n
- Request an Easysoft ODBC driver license when prompted. For example:
Would you like to request a Easysoft ODBC Driver for SQL Server license now (y/n) [y]: y
- When the installation completes, configure your ODBC driver data source. To do this, open
$ODBCSYSINI/odbc.ini
in a text editor, and then edit the sample data source created by the installation. - If you are using the client-based Oracle ODBC driver, open
$ODBCSYSINI/odbcinst.ini
in a text editor. In theDriver
andSetup
lines, replace/usr/local
with your installation path, for example,/home/myuser
. Otherwise, skip this step. - Test your data source. For example:
cd $EASYSOFT_ROOT/unixODBC/bin ./isql -v my_easysoft_sample_data_source