5.13.4.2 Installing RODBC Library

• For ORD 3.6.1
  1. curl- O https://cran.r-project.org/src/contrib/Archive/RODBC/RODBC_1.3-16.tar.gz
  2. R CMD INSTALL RODBC_1.3-16.tar.gz

     Note:

     It needs write permission to ‘/usr/lib64/R/library’ or similar root directory for system installation.
• For R 4.1.2
  1. curl- O https://cran.r-project.org/src/contrib/RODBC_1.3-19.tar.gz
  2. R CMD INSTALL RODBC_1.3-19.tar.gz

  Note:

  LD_LIBRARY_PATH should contain path to $ORACLE_HOME/lib and check that file ‘libsqora.so.19.1’ exists in $ORACLE_HOME/lib. Now, set an environment variable named RODBC_DRIVER with value ‘libsqora.so.19.1’ whichever is present in $ORACLE_HOME/lib/ directory based on the Oracle Client Version Installation.

  Now for RODBC Connection to work for Sandbox, check the TNS_ADMIN path set, and then in tnsnames.ora, add the connection string details with alias as Sandbox Name. For example, if Sandbox Name is SAND1 for which the datasource is on host abc.in.oracle.com , port 1234 and service name – ABCXYZ, then in tnsnames.ora file add the following entry-

  SAND1 =

  (DESCRIPTION =

  (ADDRESS_LIST =

  (ADDRESS = (PROTOCOL =

  TCP)(HOST=abc.in.oracle.com)(PORT=1234))

  )

  (CONNECT_DATA =

  (SERVICE_NAME = ABCXYZ)

  )

  )

  If this only does not resolve the connections, then configure odbcinst.ini. / odbc.ini files as well as mentioned in Oracle Client Installation and Setup (figured by: > odbcinst -j)