Re: [R] RODBC, IODBC and Mac OS X

From: Charles and Kimberly Maner <ckjmaner_at_carolina.rr.com>
Date: Mon 14 Mar 2005 - 04:11:09 EST

Hi. Another, slightly more updated, link to the same info is:

http://bioconductor.org/, under the Developmental Packages under Software, contains Rdbi version 1.1.1 and RdbiPgSQL version 1.1.3. I am running them under MacOSX and they work beautifully. I am using it to pull data on PostgreSQL servers running on the same machine as well as a remote FreeBSD PostgreSQL server. I'm getting quite respectable performance to boot.

Good luck,
Charles

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.htm l

Sean

> 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 Depihreux
> Managing Director
> Applied Quality Technologies Europe sprl
> Rue des Diportis 123, B4800 Verviers
> Tel : + 32 87 29 21 75
> Fax : +32 87 29 21 71
> Mobile : +32 475 555 818
> e-Mail : constant.depiereux@aqte.be
> Web presence : http://www.aqte.be
>
> ______________________________________________
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html
>



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Mon Mar 14 12:43:31 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:30:47 EST