Problem installing odbc R package on Windows

Question

I want to install odbc R package but installation failed. Apparently, I miss codecvt, but I don't know wat it is and how to get it. Somebody can help me? Thanks

I obtained the following messages :

** package 'odbc' correctement décompressé et sommes MD5 vérifiées
** using staged installation
** libs
(cd cctz && \
/Rtools/bin/make libcctz.a PREFIX="../" CC="C:/Rtools/mingw_64/bin/gcc " CXX="C:/Rtools/mingw_64/bin/g++  -std=gnu++11" AR="C:/Rtools/mingw_64/bin/ar" ARFLAGS=rv)
make[1]: Entering directory '/Users/sgoix/AppData/Local/Temp/RtmpAn9yWH/R.INSTALL17141d281ad0/odbc/src/cctz'
C:/Rtools/mingw_64/bin/g++  -std=gnu++11  -Wall -Iinclude -std=c++11 -pthread  -O  -MMD  -c -o time_zone_format.o src/time_zone_format.cc
C:/Rtools/mingw_64/bin/g++  -std=gnu++11  -Wall -Iinclude -std=c++11 -pthread  -O  -MMD  -c -o time_zone_if.o src/time_zone_if.cc
C:/Rtools/mingw_64/bin/g++  -std=gnu++11  -Wall -Iinclude -std=c++11 -pthread  -O  -MMD  -c -o time_zone_impl.o src/time_zone_impl.cc
C:/Rtools/mingw_64/bin/g++  -std=gnu++11  -Wall -Iinclude -std=c++11 -pthread  -O  -MMD  -c -o time_zone_info.o src/time_zone_info.cc
C:/Rtools/mingw_64/bin/g++  -std=gnu++11  -Wall -Iinclude -std=c++11 -pthread  -O  -MMD  -c -o time_zone_libc.o src/time_zone_libc.cc
C:/Rtools/mingw_64/bin/g++  -std=gnu++11  -Wall -Iinclude -std=c++11 -pthread  -O  -MMD  -c -o time_zone_lookup.o src/time_zone_lookup.cc
C:/Rtools/mingw_64/bin/g++  -std=gnu++11  -Wall -Iinclude -std=c++11 -pthread  -O  -MMD  -c -o time_zone_posix.o src/time_zone_posix.cc
C:/Rtools/mingw_64/bin/ar rv libcctz.a time_zone_format.o time_zone_if.o time_zone_impl.o time_zone_info.o time_zone_libc.o time_zone_lookup.o time_zone_posix.o
a - time_zone_format.o
a - time_zone_if.o
a - time_zone_impl.o
a - time_zone_info.o
a - time_zone_libc.o
a - time_zone_lookup.o
a - time_zone_posix.o
C:\Rtools\mingw_64\bin\ar.exe: creating libcctz.a
make[1]: Leaving directory '/Users/sgoix/AppData/Local/Temp/RtmpAn9yWH/R.INSTALL17141d281ad0/odbc/src/cctz'
C:/Rtools/mingw_64/bin/g++  -std=gnu++11 -I"D:/R-Portable-3.6.2/App/R-Portable/include" -DNDEBUG  -I"D:/R-Portable-3.6.2/App/R-Portable/library/Rcpp/include"     -I. -Icctz/include -Inanodbc   -O2 -Wall  -mtune=generic -c odbc_result.cpp -o odbc_result.o
C:/Rtools/mingw_64/bin/g++  -std=gnu++11 -I"D:/R-Portable-3.6.2/App/R-Portable/include" -DNDEBUG  -I"D:/R-Portable-3.6.2/App/R-Portable/library/Rcpp/include"     -I. -Icctz/include -Inanodbc   -O2 -Wall  -mtune=generic -c connection.cpp -o connection.o
C:/Rtools/mingw_64/bin/g++  -std=gnu++11 -I"D:/R-Portable-3.6.2/App/R-Portable/include" -DNDEBUG  -I"D:/R-Portable-3.6.2/App/R-Portable/library/Rcpp/include"     -I. -Icctz/include -Inanodbc   -O2 -Wall  -mtune=generic -c nanodbc/nanodbc.cpp -o nanodbc.o
nanodbc/nanodbc.cpp:40:19: fatal error: codecvt: No such file or directory
 #include <codecvt>
                   ^
compilation terminated.
make: *** [Makevars.win:17: nanodbc.o] Error 1
ERROR: compilation failed for package 'odbc'
* removing 'D:/R-Portable-3.6.2/App/R-Portable/library/odbc'
Warning in install.packages :
  installation of package ‘odbc’ had non-zero exit status

The downloaded source packages are in
    ‘C:\Users\sgoix\AppData\Local\Temp\RtmpaYbMeY\downloaded_packages’ ```

sylvaine31 sylvaine31 · Accepted Answer · 2020-06-26T13:33:53

I finally found the solution by answering "No" to the question : "There is a binary available but source is later, do you want to install from source?"

Problem installing odbc R package on Windows

1 Answers