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.
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 # exitWhile installing the RODBC package in the R client, when prompted, choose the option from the list such as "CA 96/97(CA--)" whichever works.