RODBC with Mac OS X 10.2.1
Installation completed without error messages.
Connection attempt failed.
> version
_
platform powerpc-apple-darwin6.1
arch powerpc
os darwin6.1
system powerpc, darwin6.1
status
major 1
minor 6.0
year 2002
month 10
day 01
language R
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
-o RODBC.o
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 <-
>odbcConnect('taurus',uid='macq',host='delphi.llnl.gov',pwd='a.valid.password')
/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
argument)
/Library/ODBC/OpenLink Generic ODBC Driver.bundle(0): Object Image Load Failure
Warning message:
ODBC connection failed in: odbcConnect("taurus", uid =
"macq", host =
"delphi.llnl.gov", >
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,
see below.
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[228]% pwd
/Library/ODBC/OpenLink Generic ODBC Driver.bundle
OpenLink Generic ODBC Driver.bundle[229]%
OpenLink Generic ODBC Driver.bundle[229]% find . -name oplodbc.so
./Contents/MacOS/oplodbc.so
[250]% ls /usr/lib/libio*
/usr/lib/libiodbc.2.1.6.dylib* /usr/lib/libiodbc.dylib@
/usr/lib/libiodbcinst.a
/usr/lib/libiodbc.2.dylib@
/usr/lib/libiodbcinst.2.1.6.dylib*
/usr/lib/libiodbcinst.dylib@
/usr/lib/libiodbc.a /usr/lib/libiodbcinst.2.dylib@
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...
-Don
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
>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-announce-request at
stat.math.ethz.ch
>_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
--
--------------------------------------
Don MacQueen
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._