
Hello.  I have found a number of posts/threads on this subject and
remain unsuccessful to determine the solution.  In brief, my situation
is:

1.  Running FreeBSD 4.9 Stable in x86
2.  Installed, and running, R 1.8.1
3.  Installed, and running, postgreSQL 7.4.2
4.  Installed, and running, unixODBC 2.2.8
5.  Failed, repeatedly, to install RODBC.  The
following is my error log:

tsunami# R CMD INSTALL RODBC
* Installing *source* package 'RODBC' ...
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler...
yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none
needed
checking for library containing SQLTables... no
configure: error: "no ODBC driver manager found"
ERROR: configuration failed for package 'RODBC'
** Removing '/usr/local/lib/R/library/RODBC'

I have set up the DSN/databases using ODBCConfig, viewed/confirmed
through DataManager and have even used isql to further confirm that all
is set up correctly.  I have read, numerous times, the README within
RODBC.  Unfortunately, I am out of ideas.  Therefore, I am asking for
ideas of others.

Also, I found, and employed, the results from a previous post,
https://stat.ethz.ch/pipermail/r-help/2001-October/014693.html, and
reset my LIBS and LD_LIBRARY_PATH to those suggested by the author.
Again, no joy.

So, any thoughts, with successful ones perhaps resulting in an
FAQ/how-to, would be most appreciated.

(Also, please let me know what more info you may need to help and I will
gladly provide it.)


Charles

	[[alternative HTML version deleted]]


