Skip to content

Instantly share code, notes, and snippets.

@rsangole
Created July 16, 2018 20:06
Show Gist options
  • Save rsangole/413bbf572ca0dbdac365443645366121 to your computer and use it in GitHub Desktop.
Save rsangole/413bbf572ca0dbdac365443645366121 to your computer and use it in GitHub Desktop.
> install.packages("odbc", repos = 'https://mran.microsoft.com/snapshot/2018-07-01')
Installing package into ‘/home/hw831/R/x86_64-pc-linux-gnu-library/3.3’
(as ‘lib’ is unspecified)
also installing the dependencies ‘bit’, ‘bit64’
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 54779 100 54779 0 0 295k 0 --:--:-- --:--:-- --:--:-- 0
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 122k 100 122k 0 0 0 0 621k 0 --:--:-- --:--:-- --:--:-- 622k
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 281k 100 281k 0 0 1502k 0 --:--:--:--:-- --:--:-- --:--:-- 1504k
* installing *source* package ‘bit’ ...
** package ‘bit’ successfully unpacked and MD5 sums checked
** libs
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c attrutil.c -o attrutil.o
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c bit.c -o bit.o
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c chunkutil.c -o chunkutil.o
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c clone.c -o clone.o
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c rle.c -o rle.o
gcc -std=gnu99 -shared -L/usr/local/lib64 -o bit.so attrutil.o bit.o chunkutil.o clone.o rle.o
installing to /home/hw831/R/x86_64-pc-linux-gnu-library/3.3/bit/libs
** R
** exec
** inst
** byte-compile and prepare package for lazy loading
** help
*** installing help indices
** building package indices
** testing if installed package can be loaded
* DONE (bit)
* installing *source* package ‘bit64’ ...
** package ‘bit64’ successfully unpacked and MD5 sums checked
** libs
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c bsearch.c -o bsearch.o
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c cache.c -o cache.o
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c hash64.c -o hash64.o
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c init.c -o init.o
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c integer64.c -o integer64.o
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c sort64.c -o sort64.o
gcc -std=gnu99 -I/usr/lib64/microsoft-r/3.3/lib64/R/include -DNDEBUG -I/usr/local/include -DU_STATIC_IMPLEMENTATION -fpic -DU_STATIC_IMPLEMENTATION -g -O2 -c sortuse64.c -o sortuse64.o
gcc -std=gnu99 -shared -L/usr/local/lib64 -o bit64.so bsearch.o cache.o hash64.o init.o integer64.o sort64.o sortuse64.o
installing to /home/hw831/R/x86_64-pc-linux-gnu-library/3.3/bit64/libs
** R
** data
** exec
** inst
** byte-compile and prepare package for lazy loading
** help
*** installing help indices
** building package indices
** testing if installed package can be loaded
* DONE (bit64)
* installing *source* package ‘odbc’ ...
** package ‘odbc’ successfully unpacked and MD5 sums checked
PKG_CFLAGS=
PKG_LIBS=-lodbc
<stdin>:1:17: fatal error: sql.h: No such file or directory
compilation terminated.
------------------------- ANTICONF ERROR ---------------------------
Configuration failed because odbc was not found. Try installing:
* deb: unixodbc-dev (Debian, Ubuntu, etc)
* rpm: unixODBC-devel (Fedora, CentOS, RHEL)
* csw: unixodbc_dev (Solaris)
* brew: unixodbc (Mac OSX)
To use a custom odbc set INCLUDE_DIR and LIB_DIR manually via:
R CMD INSTALL --configure-vars='INCLUDE_DIR=... LIB_DIR=...'
--------------------------------------------------------------------
ERROR: configuration failed for package ‘odbc’
* removing ‘/home/hw831/R/x86_64-pc-linux-gnu-library/3.3/odbc’
Warning in install.packages :
installation of package ‘odbc’ had non-zero exit status
The downloaded source packages are in
‘/tmp/RtmpckyRZB/downloaded_packages’
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment