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