From ripley at stats.ox.ac.uk  Thu May 13 08:23:37 2010
From: ripley at stats.ox.ac.uk (Prof Brian Ripley)
Date: Thu, 13 May 2010 07:23:37 +0100 (BST)
Subject: [Rd] R 2.11.0 on RHEL5 / RODBC
In-Reply-To: <20100512171717.H6OK1.3722893.root@mp13>
References: <20100512171717.H6OK1.3722893.root@mp13>
Message-ID: <alpine.LFD.2.00.1005130707110.20113@gannet.stats.ox.ac.uk>

On Wed, 12 May 2010, Chuck White wrote:

> I am compiling R 2.11.0 on a RHEL5.3 box using the following settings
>
> ./configure --with-readline=yes --enable-R-shlib=yes --with-x=yes --with-blas="-llibptf77blas -lpthread -llibatlas" --prefix=/usr/local/R-2.11.0 JAVA_HOME=$JAVA_HOME CPPFLAGS="-I/usr/local/unixODBC-2.3.0/include"
>
> I have compiled and installed unixODBC-2.3.0 (64-bit) in /usr/local 
> and can connect to and query the database using isql.  When I try to 
> build RODBC, I get the following error:
>
> checking for sqlext.h... yes
> checking for library containing SQLTables... no
> configure: error: "no ODBC driver manager found"
> ERROR: configuration failed for package ?RODBC?
> * removing ?/usr/local/R-2.11.0/lib64/R/library/RODBC?
>
> The directory /usr/local/unixODBC-2.3.0/lib has the files libodbc.so 
> and libodbc.la, and LD_LIBRARY_PATH has 
> /usr/local/lib64:/usr/lib64:/usr/local/unixODBC-2.3.0/lib.  Also, 
> there is no other unixODBC version on the box. I would appreciate 
> any help in this regard.  Thanks.

This is completely standard configure stuff: use

.../RODBC/configure --help

to seee the options for telling a package where the dependent 
libraries are.  It is even the reference example in 'Writing R 
Extensions'!

Does RHEL5 really not have a unixODBC (and uniODBC-devel) RPM?  They 
do make like easier for people who are out of their depth with 
software installation.

-- 

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


[Rd] R 2.11.0 on RHEL5 / RODBC
Prof Brian Ripley