Support

ODBC v1.2.3+ on CentOS/RHEL 6 & 7

Follow

When installing the R package, odbc, on CentOS/RHEL 6 and 7, a common issue is the following error:

 

fatal error: codecvt: No such file or directory

 

This error occurs because the odbc package requires full C++11 support, added in GCC 5. As the default GCC version provided by the Linux distribution does not fully support C++11, we recommend enabling the devtoolset to provide a sufficient GCC version. The following articles describe the process on RStudio Server Pro and RStudio Connect:

 

https://support.rstudio.com/hc/en-us/articles/360006145413-RStudio-Server-Pro-with-devtoolset-enabled

https://support.rstudio.com/hc/en-us/articles/360006142673-RStudio-Connect-with-devtoolset-enabled

 

An alternative is to install an older version of odbc that doesn't require C++11.  For example:


devtools::install_version('odbc', '1.2.2', repos="https://cran.rstudio.com/" )

or

install.packages("https://cran.r-project.org/src/contrib/Archive/odbc/odbc_1.2.2.tar.gz")

Comments