[Rd] R 2.11.0 on RHEL5 / RODBC

[Chuck White]

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.