I thought that maybe installing the RODBC package from source might fix the
problem:
install.packages("RODBC",type="source")
but to no success.
RODBC still gives the same warning with the same error code and very little
information to tackle the problem.
> On Apr 25, 2012, at 10:03 AM, julia.jacob...@arcor.de wrote:
>
> > Hello everybody out there using the RODBC package,
> >
> > On my linux (unixODBC) and windows machines, I can successfully use the
> RODBC package to connect to a PostgreSQL databse.
> > On my Mac Book running Mac OS X 10.6 (Intel 64bit architecture), I get the
> error "code 202" and message "?????" when I try to establish an connection
> by using
> >> con <- odbcConnect(dsn="MyDataSource",UID="Me",pwd="secret")
> > Could anyone please hint me towards additional diagnostics I can run to
> pin down the problem?
> > I have the latest versions of unixODBC and psqlODBC installed from
> Macports.
> > They seem to be okay, because
> > $isql dsn uid pwd
> > works fine to connect to the database.
> >
> > Thanks in advance for your help,
> > Julia
>
>
> Anytime Fink or MacPorts comes into the picture, I get uncontrollable
> shakes...never had good luck with them when I moved to OSX from Linux three
> years ago and they really screwed up my MacBook Pro, conflicting with all
> kinds of stuff. If I needed something, I always go to the upstream source.
>
> I can't seem to locate an error code 202 in any ODBC documentation. Is the
> above a direct copy and paste of the _complete_ error message?
>
> That being said, do you know if the MacPorts installs are 32 bit, 64 bit or
> both? The entire tool chain, including unixODBC, the ODBC driver and R must
> all be of the same architecture, or you get conflicts. Check to see which
> version of R you are running by using:
>
> .Machine$sizeof.pointer
>
> If it comes back with 8, you are running 64 bit R, if 4, then 32 bit R.
>
> Runnning:
>
> vignette("RODBC")
>
> will bring up additional installation and other relevant details on using
> RODBC, including pointers to Actual Technologies:
>
> http://www.actualtech.com/products.php
>
> which provides relatively inexpensive commercial ODBC drivers for OSX and
> which is what I use to access Oracle on OSX, using RODBC. You would want:
>
> http://www.actualtech.com/product_opensourcedatabases.php
>
> They are easy to install and configure and also provide the ODBC Manager
> app, which replaces the no longer included Apple ODBC Administrator app.
>
> Also, you should post this query (now follow ups) to R-SIG-DB, as that list
> is focused on DB access related issues:
>
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>
> Regards,
>
> Marc Schwartz
>
>
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
