Hi all, I try to install the RODBC to no avail. Where is sql.h and sqltext.h supposed to come from? I don't have such files anywhere on my hdd! After downloading latest RODBC.tar.gz, I do R CMD INSTALL RODBC and get the following: * Installing *source* package 'RODBC' ... checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking for library containing SQLTables... -lodbc configure: creating ./config.status config.status: creating src/Makevars ** libs gcc -I/usr/local/lib/R/include -I/usr/local/include -fPIC -g -O2 -c RODBC.c -o RODBC.o RODBC.c:23:17: sql.h: No such file or directory RODBC.c:24:20: sqlext.h: No such file or directory RODBC.c:44: error: parse error before "SQLCHAR" RODBC.c:44: warning: no semicolon at end of struct or union RODBC.c:45: warning: data definition has no type or storage class RODBC.c:46: error: parse error before "DataType" [... goes on like this for a while, throughtout RODBC.c ...] make: *** [RODBC.o] Error 1 ERROR: compilation failed for package 'RODBC' ** Removing '/usr/local/lib/R/library/RODBC' ** Restoring previous '/usr/local/lib/R/library/RODBC'
>From the DESCRIPTION file:SystemRequirements: An ODBC driver manager and drivers. See README. PLEASE do as it asks. On Mon, 13 Dec 2004, doktora v wrote:> Hi all, > > I try to install the RODBC to no avail. Where is sql.h and sqltext.h > supposed to come from? I don't have such files anywhere on my hdd![...]> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.htmlPlease do as we ask. -- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595