[R] RODBC, IODBC and Mac OS X

[Charles and Kimberly Maner]

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

----- Original Message ----- 
Message: 23
Date: Sat, 12 Mar 2005 18:07:55 -0500
From: "Sean Davis" <sdavis2 at mail.nih.gov>
Subject: Re: [R] RODBC, IODBC and Mac OS X
To: <r-help at stat.math.ethz.ch>,	"Depiereux Constant"
	<constant.depiereux at aqte.be>
Message-ID: <000e01c52758$538b71a0$1f6df345 at WATSON>
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=response

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

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


> 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 at aqte.be
> Web presence : http://www.aqte.be
>
> ______________________________________________
> R-help at 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
>