[R] Help Installing RODBC with custom header locations

[Marc Schwartz]

> On Feb 1, 2017, at 8:11 AM, Ivan Gomez <igomez at zencos.com> wrote:
> 
> Hi all,
> 
> I'm trying to install.packages("RODBC") , but it is failing because it cannot find certain required header files:
> 
> ....
> "configure: error: "ODBC headers sql.h and sqlext.h not found"
> 
> I believe this is because my header files are in a custom location instead of the standard system folder:
> 
> comp1:/gpfs/grid/progress/include # ll
> total 184
> -rw-r--r--. 1 1494 400 4894 Oct 24 2012 odbcinst.h
> -rw-r--r--. 1 1494 400 26858 Oct 24 2012 qesqlext.h
> -rw-r--r--. 1 1494 400 79606 Oct 24 2012 sqlext.h
> -rw-r--r--. 1 1494 400 30106 Oct 24 2012 sql.h
> -rw-r--r--. 1 1494 400 8002 Oct 24 2012 sqltypes.h
> -rw-r--r--. 1 1494 400 22715 Oct 24 2012 sqlucode.h
> -rw-r--r--. 1 1494 400 1354 Oct 24 2012 sqlunx.h
> 
> 
> 
> Could you please show me how I can tell the install command to look for the header files in this custom directory or point me towards an example of a similar case?
> Thank you very much for your time,
> Ivan G.
> 


Hi,

For future reference, this subject matter should go to R-SIG-DB:

  https://stat.ethz.ch/mailman/listinfo/r-sig-db


You can use an invocation along the lines of:

install.packages("RODBC",
                 configure.args = "--with-odbc-include=/gpfs/grid/progress/include/")

where the 'configure.args' argument has the FULL path to the header files.

There is detailed installation information in the vignette for the package on CRAN:

  https://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf


Regards,

Marc Schwartz