[R] Problems installing RODBC as part of Rcmdr and as separate package

[Prof Brian Ripley]

You need unixODBC or iodbc.  Specifically on F10

gannet% rpm -q --whatprovides /usr/include/sql.h
unixODBC-devel-2.2.12-9.fc10.x86_64

This is in the RODBC/README (well, not the exact RPM for F10).

On Fri, 20 Feb 2009, John Sorkin wrote:

> Fedora 10
> R 2.8.1
>
> I hope someone can tell me the meaning of error I received trying to 
> install RODBC and how I can get around the problem. n.b. The error 
> originally occurred then I was installing Rcmdr. I then tried to 
> install RODBC separately and received the same error.
>
> 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/lib/R/library/RODBC'
>
> The downloaded packages are in
> 	/tmp/RtmpA1nKF2/downloaded_packages
> Updating HTML index of packages in '.Library'
> Warning message:
> In install.packages("RODBC") :
>  installation of package 'RODBC' had non-zero exit status
>
>
> John Sorkin M.D., Ph.D.
> Chief, Biostatistics and Informatics
> Baltimore VA Medical Center GRECC,
> University of Maryland School of Medicine Claude D. Pepper OAIC,
> University of Maryland Clinical Nutrition Research Unit, and
> Baltimore VA Center Stroke of Excellence
>
> University of Maryland School of Medicine
> Division of Gerontology
> Baltimore VA Medical Center
> 10 North Greene Street
> GRECC (BT/18/GR)
> Baltimore, MD 21201-1524
>
> (Phone) 410-605-7119
> (Fax) 410-605-7913 (Please call phone number above prior to faxing)
> jsorkin at grecc.umaryland.edu

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