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 linked articles here describe the process on RStudio Workbench (previously 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="" )