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
I have the latest versions of unixODBC and psqlODBC installed from
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.