[R] Help Installing RODBC with custom header locations

[Ivan Gomez]

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]]