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,                  rip...@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
______________________________________________
R-devel@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel

Reply via email to