R-help, I'm now on the process of installing RODBC on UBUNTU but an error occured. I copy-paste the output:> install.packages("RODBC")Warning in install.packages("RODBC") : argument 'lib' is missing: using '/home/luisridaocruz/R/x86_64-pc-linux-gnu-library/2.8' trying URL 'http://cran.ii.uib.no/src/contrib/RODBC_1.2-6.tar.gz' Content type 'application/x-gzip' length 123956 bytes (121 Kb) opened URL =================================================downloaded 121 Kb * Installing *source* package 'RODBC' ... checking for gcc... gcc -std=gnu99 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 -std=gnu99 accepts -g... yes checking for gcc -std=gnu99 option to accept ANSI C... none needed checking how to run the C preprocessor... gcc -std=gnu99 -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 '/home/luisridaocruz/R/x86_64-pc-linux-gnu-library/2.8/RODBC' The downloaded packages are in /tmp/RtmpWqXfbD/downloaded_packages Warning message: In install.packages("RODBC") : installation of package 'RODBC' had non-zero exit status ############# ############# $ uname -a Linux ubuntu 2.6.28-11-generic #42-Ubuntu SMP Fri Apr 17 01:58:03 UTC 2009 x86_64 GNU/Linux> version_ platform x86_64-pc-linux-gnu arch x86_64 os linux-gnu system x86_64, linux-gnu status major 2 minor 8.1 year 2008 month 12 day 22 svn rev 47281 language R version.string R version 2.8.1 (2008-12-22) ###### ######
Luis, On 24 June 2009 at 16:35, Luis Ridao Cruz wrote: | R-help, | | I'm now on the process of installing RODBC on UBUNTU | but an error occured. I copy-paste the output: You can simply do $ sudo apt-get install r-cran-rodbc As for the error: | > install.packages("RODBC") [...] | configure: error: "ODBC headers sql.h and sqlext.h not found" That is about as plain as it gets. You need these headers. There is also README in the sources with more detail. If you're in a hurry, why don't you a) install the binary packafe and b) learn about the CRAN repository for Ubuntu that has binaries of R 2.9.0 for you and c) consider subscribing to the r-sig-debian list we have for Debian and Ubuntu questions. Hth, Dirk -- Three out of two people have difficulties with fractions.