From chuckwhite8 at charter.net  Wed May 12 23:17:17 2010
From: chuckwhite8 at charter.net (Chuck White)
Date: Wed, 12 May 2010 17:17:17 -0400
Subject: [Rd] R 2.11.0 on RHEL5 / RODBC
Message-ID: <20100512171717.H6OK1.3722893.root@mp13>

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.



[Rd] R 2.11.0 on RHEL5 / RODBC
Chuck White