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