[R] RODBC on Mac

[Mikkel Grum]

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.