iODBC appears no longer to come standard with OSX, so I installed unixodbc and
set it up following instructions
here:?http://www.boriel.com/en/2013/01/16/postgresql-odbc-connection-from-mac-os-x/
I connected to my remote database with isql -v mydsn. No problem. Then I tried
from R:
> library(RODBC)
> pg <- odbcConnect("mydsn") ?# waited for a couple of minutes
before pressing Ctrl-C
^C
There were 50 or more warnings (use warnings() to see the first
50)> warnings()[1:2]
Warning messages:
1: In odbcDriverConnect("DSN=mydsn") :
? [RODBC] ERROR: state IM002, code 1606406032, message [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver could
not be loaded
2: In odbcDriverConnect("DSN=mydsn") :
? [RODBC] ERROR: state IM002, code 1606406032, message [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver could
not be loaded
It looks like RODBC might only work with iODBC on the Mac. Is that the case? I
haven't been able to configure iODBC correctly, and therefore haven't
been able to test whether that would work with RODBC. Any chance that I can get
RODBC to work with unixodbc? Any other information that would be useful in
resolving it?
> sessionInfo()
R version 3.0.2 (2013-09-25)
Platform: x86_64-apple-darwin10.8.0 (64-bit)
locale:
[1] C/UTF-8/C/C/C/C
attached base packages:
[1] stats ? ? graphics ?grDevices utils ? ? datasets ?methods ? base ? ??
other attached packages:
[1] RODBC_1.3-8
Regards
Mikkel
PS. Apologies for repeating this message. I previously sent it with HTML
formatting.