Download the UNIX ODBC driver (http://www.unixodbc.org/unixODBC-2.3.1.tar.gz) and install it using the Linux "root" privilege account.
#su -
-
Download and copy the UNIX ODBC driver to the sandbox area of root.
# cd /opt/aster/third-party/R/root # wget http://www.unixodbc.org/unixODBC-2.3.1.tar.gz # tar -xvzf ./unixODBC-2.3.1.tar.gz
-
Compile and make the driver software inside the sandbox area.
# export ODBCSYSINI=/root # chroot /opt/aster/third-party/R # cd root/unixODBC-2.3.1 # CFLAGS="-DSIZEOF_LONG=8" ./configure --prefix=/usr --enable-fdb --disable-gui && make # make install # exit
-
Check the installation.
# su - # chroot /opt/aster/third-party/R # export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib:/usr/local/lib/stage/clients-odbc-linux64/unixODBC/lib # export ODBCSYSINI=/root # odbcinst -j unixODBC 2.3.1 DRIVERS............: /root/odbcinst.ini SYSTEM DATA SOURCES: /root/odbc.ini FILE DATA SOURCES..: /root/ODBCDataSources USER DATA SOURCES..: /root/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8 # exit
Users must make sure to exit out of the sandbox are by executing the exit command as shown here.