> On May 5, 2017, at 7:51 AM, Spencer Graves <spencer.gra...@prodsyse.com>
> 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 Graves
Spencer,
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.
Regards,
Marc
_______________________________________________
R-SIG-Mac mailing list
R-SIG-Mac@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
