[R] RODBC fail install

[Uwe Ligges]

R Gott wrote:

> 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?


The root directory of that package has a file called README. Please read 
it. It tells you about requirements and how to install RODBC.


> ta v much

Your keyboard seems to be seriously damaged, you might want to replace 
it by a better one.

Uwe Ligges




> 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"))
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html