[R] Re: RODBC update
macq at llnl.gov
Thu Oct 31 00:46:17 CET 2002
RODBC with Mac OS X 10.2.1
Installation completed without error messages.
Connection attempt failed.
system powerpc, darwin6.1
The gcc commands from the installation step were
gcc -no-cpp-precomp -I/Users/macq/R/R-1.6.0/build/include
-I/sw/include -I/usr/local/include -fno-common -g -O2 -c RODBC.c
gcc -bundle -flat_namespace -undefined suppress -L/sw/lib
-L/usr/local/lib -o RODBC.so RODBC.o -liodbc
Connection attempt failed (blank lines inserted for readability):
> chn <-
/Users/macq/R/R-1.6.0/build/bin/R.bin: can't map file:
/Library/ODBC/OpenLink Generic ODBC Driver.bundle ((os/kern) invalid
/Library/ODBC/OpenLink Generic ODBC Driver.bundle(0): Object Image Load Failure
ODBC connection failed in: odbcConnect("taurus", uid = "macq", host =
The DSN, uid, host, and password are valid in the sense that they
work with at least one OS X native odbc client: Microsoft Excel.
The ODBC driver that R found is partially correct, in that it is from
OpenLink (www.openlinksw.com). Installing the OpenLink driver in OS X
also installed an application called iODBC Administrator which is
used to configure the driver, and some iodbc libraries in /usr/local,
Within the "OpenLink Generic ODBC Driver.bundle" is a file named
oplodbc.so, which might be the file RORACLE is looking for when it
generates the error message?
OpenLink Generic ODBC Driver.bundle% pwd
/Library/ODBC/OpenLink Generic ODBC Driver.bundle
OpenLink Generic ODBC Driver.bundle%
OpenLink Generic ODBC Driver.bundle% find . -name oplodbc.so
% ls /usr/lib/libio*
Or maybe configure should have found the dylibs?
Maybe I should put a link oplodbc.so somewhere where configure can
find it? In /usr/lib? Just making wild guesses here...
At 2:21 PM +0000 10/30/02, <ripley at stats.ox.ac.uk> wrote:
>There is a new version of RODBC, 0.9-1, with a new maintainer (me)
>now on CRAN (Vienna) which works with R 1.6.x. The Windows binary
>will be there tomorrow, and both will then propagate around CRAN.
>This has been tested on Linux under unixODBC against MySQL and Postgresql
>(thanks to Dirk Edelbuettel), and on Windows against Access, MySQL and
>Excel. The CRAN compilation checks were against iODBC.
>I had to make quite a lot of internal changes, so would appreciate
>success/problem reports for other uses.
>There are several improvements in this version, some of which I had
>previously submitted to Michael Lapsley: see the ChangeLog. I am
>moving towards a 1.0 release which will be somewhat incompatible
>(`channel' will be a classed object and quoting names will be
>essential to allow them to be passed as R variables, for example).
>In the longer term the planned DBI/ODBC interface may replace RODBC
>entirely via a back-compatibility wrapper.
>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 272860 (secr)
>Oxford OX1 3TG, UK Fax: +44 1865 272595
>r-announce mailing list -- Read
>Send "info", "help", or "[un]subscribe"
>(in the "body", not the subject !) To: r-announce-request at stat.math.ethz.ch
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch
More information about the R-help