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


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:


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="" )