R help - Feb 2009 - Problems installing RODBC as part of Rcmdr and as separate package

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
Confidentiality Statement:
This email message, including any attachments, is for th...{{dropped:6}}

on 02/20/2009 09:27 AM 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,

As root:

  yum install unixODBC unixODBC-devel

You need the unixODBC and the devel RPMs, the latter of which provides
the requisite header files.

HTH,

Marc Schwartz

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