R help - Mar 2006 - RODBC fail install

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"))

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

On Tue, 7 Mar 2006, R Gott wrote:
> I'm a newcomer - obvioulsly I fear.  Tried to install RODBC from CRAN
> mirror onto mahcine 64bit running suse10.
Well, we need to know more than that: see the posting guide for how to 
report your platform.  It may matter which 64-bit platform.
> terminal log below - it failed on "ODBC headers sql.h and sqlext.h not
> found"
>
> di i need anothe rpackage??
Yes, see the package's README which is intended to be .... read.  It says

   An ODBC driver manager needs to be installed, as well as an ODBC
   driver for each database to be used.  Testing is done using unixODBC
   (http://www.unixODBC.org), but iOBDC (http://www.iODBC.org) has also
   been used.  The RODBC package is installed in the standard way (R CMD
   INSTALL RODBC) and needs the ODBC driver manager header files and
   library (-lodbc or -lodbc32 or -liodbc) to be available.  Use the
   configure options --with-odbc-include and --with-odbc-lib or
   environment variables ODBC_INCLUDE and ODBC_LIBS to set the include
   and library paths as needed.

There are some known problems with RODBC/unixODBC on 64-bit Debian, but 
they should not affect SuSE as far as I know.  (unixODBC can be compiled 
in two separate ways, and one uses features from ODBC 3.52 whilst only 
declaring itself to use 3.51.  But the default as used by FC3/4 does not. 
A workaround is under testing.)
>
> 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"))
>
> ______________________________________________
> 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
>
-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595