If users have Internet access from the queen node, then users can install the RODBC driver using the R client inside the R sandbox area. Follow the steps in this section, and complete this procedure using the Linux root privileges account.
#su –
If users do not have Internet access from the queen node, this task can be done by downloading the RODBC package from the CRAN website https://cran.r-project.org/src/contrib and installing the package on the queen node using the R CMD command.
-
Soft shutdown the Aster Database.
# ncli system softshutdown
-
Set up the environment.
# 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 ODBC_INCLUDE="/usr/include" # export ODBC_LIBS="/usr/lib" # export LD_RUN_PATH="/usr/lib"
-
Install the RODBC using the R client.
# R >install.packages("RODBC") > q() Save workspace image? [y/n/c]: n # exit
While installing the RODBC package in the R client, when prompted, choose the option from the list such as "CA 96/97(CA--)" whichever works.