Skip to content

RODBC, IODBC and Mac OS X

2 messages · Depiereux Constant, Sean Davis

#
Dear All,

As some of you in the archive, i am experiencing problems in using 
RODBC with IODBC on Mac OS X Panther.

I am currrently facing two problems.

The first one is apparently linked with IODBC (according to returned R 
error message) although testing the database access from IODBC manager 
seems to work fine.

The second is by far more radical, R purely and simply reports an error 
, blocks and I finally got a Mac OS X message.

I browsed the archive without really finding a solution. Before 
spending lengthy hours on an operating system that I am currently 
discovering, I have therefore a simple question :

DOES ANY BODY HAVE A COOKBOOK EXPLAINING HOW TO ACCESS - THRU ODBC - A 
POSTGRESQL DATABASE USING R ON MAC OS X PANTHER ?

Thanks in advance for your help.





Constant Depi?reux
Managing Director
Applied Quality Technologies Europe sprl
Rue des D?port?s 123, B4800   Verviers
Tel : + 32 87 29 21 75
Fax : +32 87 29 21 71
Mobile : +32 475 555 818
e-Mail : constant.depiereux at aqte.be
Web presence : http://www.aqte.be
#
Have you looked at these two packages that, together, provide Postgres 
access and do not require ODBC?  I have found them quite useful and I use 
them on Panther:

http://www.bioconductor.org/repository/release1.5/package/html/Rdbi.html
http://www.bioconductor.org/repository/release1.5/package/html/RdbiPgSQL.html

Sean

----- Original Message ----- 
From: "Depiereux Constant" <constant.depiereux at aqte.be>
To: <r-help at stat.math.ethz.ch>
Sent: Saturday, March 12, 2005 5:21 PM
Subject: [R] RODBC, IODBC and Mac OS X