7.00.02.01 - Installing the UNIX ODBC Driver - Aster R

Teradata Aster® R User GuideUpdate 3

prodname
Aster R
vrm_release
7.00.02.01
created_date
December 2017
category
Programming Reference
User Guide
featnum
B700-1033-700K

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 -
  1. 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
  2. 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
  3. 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.