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/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