[R] Re: RODBC update

[Don MacQueen]

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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._