Skip to content

Problems installing RODBC as part of Rcmdr and as separate package

4 messages · John Sorkin, Marc Schwartz, Brian Ripley

John Sorkin
# 
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}}
Marc Schwartz
#
on 02/20/2009 09:27 AM John Sorkin wrote:
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
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:

            

      
      
      
    

        

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      John Sorkin
    

    

      
      #
    

  


  

      
Marc Schwarz's solution solved my problem.
Thank you Marc!

John

John David Sorkin M.D., Ph.D.
Chief, Biostatistics and Informatics
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)

            

      
      
      
    

        
on 02/20/2009 09:27 AM John Sorkin wrote:

            

      
      
      
    

        
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

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help 
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html 
and provide commented, minimal, self-contained, reproducible code.

Confidentiality Statement:
This email message, including any attachments, is for th...{{dropped:6}}