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_schwa...@me.com]
Sent: Wednesday, February 01, 2017 10:31 AM
To: Ivan Gomez <igo...@zencos.com>
Cc: R-help <r-help@r-project.org>
Subject: Re: [R] Help Installing RODBC with custom header locations
> On Feb 1, 2017, at 8:11 AM, Ivan Gomez <igo...@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
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
