[R] Installing RODBC

Marc Schwartz marc_schwartz at me.com
Thu Aug 21 01:03:52 CEST 2014

On Aug 20, 2014, at 5:43 PM, William Deese <williamdeese at gmail.com> wrote:

> I tried installing RODBC but got the following message:
> Checks were yes until the following
> checking sql.h usability... no
> checking sql.h presence... no
> checking for sql.h... no
> checking sqlext.h usability... no
> checking sqlext.h presence... no
> checking for sqlext.h... no
> configure: error: "ODBC headers sql.h and sqlext.h not found"
> ERROR: configuration failed for package ‘RODBC’
> * removing ‘/home/bill/R/x86_64-pc-linux-gnu-library/3.1/RODBC’
> Apparently RODBC was there when R was installed, but library() shows
> it is not there now, although the DBI package is. Best ideas for
> installing RODBC?
> Bill

You are missing the indicated header files, which are required if you are building the package from source.

As per the extensive vignette that Prof. Ripley has provided:


in Appendix A, which describes Installation, you will find:

"For other systems the driver manager of choice is likely to be unixODBC, part of almost all Linux distributions and with sources downloadable from http://www.unixODBC.org. In Linux binary distributions it is likely that package unixODBC-devel or unixodbc-dev or some such will be needed."

Thus, for whatever Linux distribution you are using, install the relevant RPMs or Debs or ...

Also, for future reference, there is a specific mailing list for DB related queries:


and a search of the list archives, for example using rseek.org, would likely result in your finding queries and answers to this same issue over the years.


Marc Schwartz

More information about the R-help mailing list