On 2017-05-05 8:38 AM, Marc Schwartz wrote:
On May 5, 2017, at 7:51 AM, Spencer Graves <[email protected]> wrote: Hello: I recently upgraded to R 3.4.0, and I've so far been unable to "install.packages('RODBC')" or "R CMD INSTALL RODBC_1.3-15.tar.gz". Both end with the following: configure: error: "ODBC headers sql.h and sqlext.h not found" ERROR: configuration failed for package ‘RODBC’ I had RODBC installed in R 3.3, but that was before I upgraded to macOS Sierra 10.12.4. I've tried to RTFM, but I don't know which FMTR, and I can't decrypt the documentation I've found that seem relevant. I couldn't find the answer in Ripley's "ODBC Connectivity" vignette. "iodbc-42.5/iodbc/README.MACOSX" says, "You first need to install the latest Mac OS X Developer Packages, which can be found at "http://developer.apple.com/tools";. I think I've done that, but I don't know how to check it. "iodbc-42.5/iodbc/README.MACOSX" continues, "Then, you can open the Xcode Project Builder files under mac/iODBCinst, mac/iODBC, mac/iODBCtest and mac/iODBCtestw,". I don't know how find any of these. It further continues, "or execute the following commands from a terminal session to build all the frameworks and demo applications: $ cd mac $ make" I just did "$ cd mac" and got, "-bash: cd: mac: No such file or directory". Evidently, I need to substitute something for "mac" here, but I don't know what. Suggestions? Thanks, Spencer GravesSpencer, The incantation that I use is: install.packages("RODBC", type = "source", configure.args = "--with-odbc-include=/PATH.TO/iODBC/libiodbc-3.52.12/include/") where the header files are located in the 'include' folder above, which is extracted from the iODBC source tarball available here: http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads#Stable%20Version%203.52.12 There is information in Prof. Ripley's RODBC vignette in Appendix A Installation on page 19.
Hi, Marc: Thanks. With your encouragement, I reread p. 19 of Ripley's RODBC vignette you mentioned, and got that to work. (It contains a stray quote <'>, which confused me the first few times I read it, because I was not familiar with that syntax. I also posted this question and and my answer with your suggestions to StackOverflow (http://stackoverflow.com/questions/43804850/how-to-install-rodbc-on-macos-sierra-10-12-4/43808419#43808419). Spencer Graves
Regards, Marc
_______________________________________________ R-SIG-Mac mailing list [email protected] https://stat.ethz.ch/mailman/listinfo/r-sig-mac
