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. [[alternative HTML version deleted]]
Marc Schwartz
2017-Feb-01 15:31 UTC
[R] Help Installing RODBC with custom header locations
> 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
Hi Marc, Thank you so much for your response. I'll keep in mind R-SIG-DB for future reference. Just to close this loop, what ultimately did the trick was: 1. Setting the following environment variables LD_LIBRARY_PATH=/gpfs/grid/progress/lib:$LD_LIBRARY_PATH ODBCINI=/gpfs/grid/progress/odbc.ini ODBCINST=/gpfs/grid/progress/odbcinst.ini 2. Running this install command `install.packages("RODBC", configure.args = "--with-odbc-include=/gpfs/grid/progress/include/ --with-odbc-lib=/gpfs/grid/progress/lib/")` Thank you for your help and have a good day, Ivan G. -----Original Message----- From: Marc Schwartz [mailto:marc_schwartz at me.com] Sent: Wednesday, February 01, 2017 10:31 AM To: Ivan Gomez <igomez at zencos.com> Cc: R-help <r-help at r-project.org> Subject: Re: [R] Help Installing RODBC with custom header locations> 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