[R-sig-DB] [R] RODBC Error Code 202 on Mac OS X 10.6

[juii@@j@cobso@ m@iii@g oii @rcor@de]

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

> Unfortunately, I'm not really making any progresses, despite a lot of
> effort.
> I've compiled R on Mac OS X for myself using MacPorts and the error is now
> "state 28000, code 201" which is failed password authentification.

Interestingly, I was able to set up RODBC on Mac OS X 10.4 (PowerPC architecture) successfully and as I said, it does work on Linux and Windows XP/7 perfectly.
I was wondering whether the undecipherable error message I get on OS X 10.6 is due to wrong encoding settings on my machine in relation to the ones on the server. It would already be of great help to be able to read the error message.
It is probably a problem of the versions of the OS, psqlODBC, R and RODBC on my machine.
It would be great to get feedback from someone running Mac OS X 10.6 in combination with RODBC successfully and check for the differences with my setup.