Displaying 1 result from an estimated 1 matches for "mydatasource".
Did you mean:
datasource
2012 Apr 25
3
RODBC Error Code 202 on Mac OS X 10.6
...chines, 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 da...