[R] RODBC fail install

R Gott richard.gott at dur.ac.uk
Tue Mar 7 10:38:30 CET 2006


I'm a newcomer - obvioulsly I fear.  Tried to install RODBC from CRAN 
mirror onto mahcine 64bit running suse10.

terminal log below - it failed on "ODBC headers sql.h and sqlext.h not 
found"

di i need anothe rpackage??

can someone help please?

ta v much

Prof R Gott
Durham UNiv, UK

 >  install.packages(c("RODBC"))
trying URL 'http://cran.uk.r-project.org/src/contrib/RODBC_1.1-5.tar.gz'
Content type 'application/x-gzip' length 69366 bytes
opened URL
==================================================
downloaded 67Kb

* Installing *source* package 'RODBC' ...
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking how to run the C preprocessor... gcc -E
checking for egrep... grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking sql.h usability... no
checking sql.h presence... no
checking for sql.h... no
checking sqlext.h usability... no
checking sqlext.h presence... no
checking for sqlext.h... no
configure: error: "ODBC headers sql.h and sqlext.h not found"
ERROR: configuration failed for package 'RODBC'
** Removing '/usr/lib64/R/library/RODBC'

The downloaded packages are in
        /tmp/RtmpRZ8266/downloaded_packages
Warning message:
installation of package 'RODBC' had non-zero exit status in: 
install.packages(c("RODBC"))




More information about the R-help mailing list