Skip to content

Problem Installing RODBC under RedHat 7.3

3 messages · Richards, Tom, Brian Ripley, Roger Bivand

Original
Richards, Tom
# 
Hello:

Using Redhat 7.3 and
platform i686-pc-linux-gnu
arch     i686             
os       linux-gnu        
system   i686, linux-gnu  
status                    
major    1                
minor    6.1              
year     2002             
month    11               
day      01               
language R                

I am trying to install the RODBC package.  Upon using
I get the following:

checking for gcc... gcc
checking for C compiler default output... 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 for library containing SQLTables... no
configure: error: "no ODBC driver manager found"
ERROR: configuration failed for package 'RODBC'

Delete downloaded files (y/N)? y

Warning message: 
Installation of package RODBC had non-zero exit status in: install.packages("RODBC") 

Earlier I retrieved an rpm file called unixODBC-2.1.1-1.i386.rpm

and I used

rpm -i unixODBC-2.1.1-1.i386.rpm

and received no message of any kind, error or otherwise.

What should I do next, Linux neophyte that I am?

Thanks in advance.

Tom

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Brian Ripley
# 
Sorry, but this is a question about the installation of unixODBC, not of
RODBC.  Several of us have test-installed RODBC on systems which do have
unixODBC installed.  That message indicates that the unixODBC libraries
cannot be found.

FWIW, the current version appears to be 2.2.3, and that comes with a
program isql to test ODBC connections.  That may help you debug this.
On Mon, 4 Nov 2002, Richards, Tom wrote:

            

      
      
      
    

        

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      Roger Bivand
    

    

      
      #
    

  


  

          

      
      
      
    

        
maybe rpm -i unixODBC-devel-2.1.1-1.i386.rpm

(although from rpmfind, it looks as though the RH73 versions are:
unixODBC-devel-2.2.0-5.i386.rpm and unixODBC-2.2.0-5.i386.rpm)

It seems to be an FAQ for RedHat and other RPM users that installing the
base package only installs the runtime libraries, but to install R
packages, you always also need the *-devel-*.rpm too. Check what:

rpm -qa | grep <your_target>

says - if there is no *-devel-* package, install it!

Roger