Easysoft Data AccessHow do I install an Easysoft ODBC driver on a machine where I have no root access? |
|
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 an easysoft subdirectory of the installation_path you specify. For example, if you want to install the driver under /home/myuser, type this command:
export EASYSOFT_ROOT=/home/myuser/easysoft
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 and odbc.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.
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 see which environment variables you need to set (LD_LIBRARY_PATH, LIBPATH, LD_RUN_PATH, SHLIB_PATH or ORACLE_HOME depending on the driver, platform and linker).
tar -xvf odbc-sqlserver-1.2.0-sunos-sparc.tar
cd to the directory created by untarring the distribution. Run the installation. For example:
cd odbc-sqlserver-1.2.0-sunos-sparc ./install
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
Enter a base install directory (q=quit) [ /usr/local ]: /home/myuser
Note Do not append /easysoft to the directory you specify. The installation automatically creates the easysoft subdirectory. So, if, before running the installation, you set EASYSOFT_ROOT to /home/myuser/easysoft, you would specify /home/myuser not /home/myuser/easysoft.
Do you want to use your installed unixODBC DM in preference to the version included with this distribution? (y/n [n]) : n
Would you like to request a Easysoft ODBC Driver for SQL Server license now (y/n) [y]: y
$ODBCSYSINI/odbc.ini in a text editor, and then edit the sample data source created by the installation.$ODBCSYSINI/odbcinst.ini in a text editor. In the Driver and Setup lines, replace /usr/local with your installation path, for example, /home/myuser. Otherwise, skip this step.cd $EASYSOFT_ROOT/unixODBC/bin ./isql -v my_easysoft_sample_data_source