Hi,
I have recently installed R 2.13.1-1 from Cygwin Ports.
After adding few missing libraries (e.g. make, gcc4-core) I am now
able to install packages under R on my system (e.g.
install.packages('ggplot2') ).
Right now I am still unable to install the RODBC package under cygwin-R.
I have no idea on how ODBC works under cygwin (does it communicate to
the windows ODBC drivers? do I need to install an ODBC manager under
cygwin?), but right now the problem is that I get warnings and errors
when I try to install RODBC under cygwin-R (see below). As you can see
the main error is "no ODBC driver manager found", and the warnings are
relative to sql.h and sqlext.h.I was going to post this problem to an R mailing list, but I just noticed that back in 2009 there was an R-RODBC package as part of cygwin ports: http://cygwin-ports.git.sourceforge.net/git/gitweb.cgi?p=cygwin-ports/R-RODBC;a=summary That version was RODBC 1.2-5, and the current version is now RODBC 1.3-3. Does that imply that the standard installation procedure under R (install.packages) will not work for R under cygwin, and that the RODBC package needs some kind of tweak in order to be compiled correctly? Was R-RODBC no longer updated under cygwin ports since a special installation is no longer needed? Please let me know if you have any experience with RODBC under cygwin ports, or if you recommend posting this question to a different mailing list. I noticed a libiodbc package under cygwin ports, and I might try to install it over the weekend. Any help is greatly appreciated in the meantime. Thanks, Dario $ r R version 2.13.1 (2011-07-08) Copyright (C) 2011 The R Foundation for Statistical Computing ISBN 3-900051-07-0 Platform: i686-pc-cygwin (32-bit) [...] > install.packages('RODBC') Installing package(s) into ‘/usr/lib/R/site-library’ (as ‘lib’ is unspecified) trying URL 'http://cran.stat.ucla.edu/src/contrib/RODBC_1.3-3.tar.gz' Content type 'application/x-tar' length 1063140 bytes (1.0 Mb) opened URL ================================================== downloaded 1.0 Mb * installing *source* package ‘RODBC’ ... checking for gcc... gcc checking for C compiler default output file name... a.exe checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... .exe 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... yes configure: WARNING: sql.h: present but cannot be compiled configure: WARNING: sql.h: check for missing prerequisite headers? configure: WARNING: sql.h: see the Autoconf documentation configure: WARNING: sql.h: section "Present But Cannot Be Compiled" configure: WARNING: sql.h: proceeding with the preprocessor's result configure: WARNING: sql.h: in the future, the compiler will take precedence configure: WARNING: ## ------------------------------------ ## configure: WARNING: ## Report this to [email protected] ## configure: WARNING: ## ------------------------------------ ## checking for sql.h... yes checking sqlext.h usability... no checking sqlext.h presence... yes configure: WARNING: sqlext.h: present but cannot be compiled configure: WARNING: sqlext.h: check for missing prerequisite headers? configure: WARNING: sqlext.h: see the Autoconf documentation configure: WARNING: sqlext.h: section "Present But Cannot Be Compiled" configure: WARNING: sqlext.h: proceeding with the preprocessor's result configure: WARNING: sqlext.h: in the future, the compiler will take precedence configure: WARNING: ## ------------------------------------ ## configure: WARNING: ## Report this to [email protected] ## configure: WARNING: ## ------------------------------------ ## checking for sqlext.h... yes checking for library containing SQLTables... no configure: error: "no ODBC driver manager found" ERROR: configuration failed for package ‘RODBC’ * removing ‘/usr/lib/R/site-library/RODBC’ ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA Learn about the latest advances in developing for the BlackBerry® mobile platform with sessions, labs & more. See new tools and technologies. Register for BlackBerry® DevCon today! http://p.sf.net/sfu/rim-devcon-copy1 _______________________________________________ Cygwin-ports-general mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/cygwin-ports-general
