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