Date: Wed, 9 Nov 2005 15:18:59 +0100 (GMT+01:00) From: Vittorio <vdemart1@tin.it> To: r-help@stat.math.ethz.ch Cc: freebsd-questions@freebsd.org Subject: R: Re: [R] RODBC fails to build Message-ID: <18975192.1131545939684.JavaMail.root@pswm15.cp.tin.it>
next in thread | raw e-mail | index | archive | help
Dear All, Thanks to the suggestion of Prof Ripley I progressively=20 solved the many libraries problems connected to the installation of the=20 R package RODBC under FreeBSD 5.4.=20 *** As far as this OS is concerned=20 *** please take notice that the sentence in the README file:"..... Use=20 the configure options --with-odbc-include and --with-odbc-lib or environment variables ODBC_INCLUDE and ODBC_LIBS to set the include and=20 library paths as needed...." doesn't give a complete piece of info. As=20 a matter of fact, as well as setting $ODBC_INCLUDE=3D/usr/local/include=20 and $ODBC_LIBS=3D/usr/local/lib I had also to put ** $LIBS=3D- L/usr/local/lib ** which wasn't in the README (and wasn't that=20 intuitive, was it?). In so doing I solved the sql.h, sqlext.h headers=20 problem and a successive problem with the SQLTables libraries. This set=20 things straight and RODBC was compiled flawlessly. I think it would be=20 worth your while adding this piece of information in the README file. Ciao Vittorio =20 >----Messaggio originale---- >Da: vdemart1@tin.it >Data: 8-nov-2005 11.45 PM >A: <r-help@stat.math.ethz.ch> >Ogg: Re: [R]=20 RODBC fails to build > >yes, I read it. Nevertheless I can't make head=20 or tail of it. >Can anyone out there help me with a step by step=20 explanation? >Ciao >Vittorio > >Alle 17:34, marted=C3=AC 08 novembre 2005,=20 Prof Brian Ripley ha scritto: >> Did you read the package's README? It=20 contains two ways to set these >> paths. >> >> On Tue, 8 Nov 2005,=20 Vittorio wrote: >> > Context:Pentium 4, FreeBSD 5.4, R 2.2.0 >> > >> >=20 I updated the extra packages I >> > had downloaded but the upgrading of=20 RODBC failed complaining: >> > >> > checking >> > for unistd.h... yes >> > checking sql.h usability... no >> > checking sql.h >> >=20 presence... no >> > checking for sql.h... no >> > checking sqlext.h=20 usability... >> > no >> > checking sqlext.h presence... no >> >=20 checking for sqlext.h... no >> > configure: error: "ODBC headers sql.h=20 and sqlext.h not found" >> > ERROR: >> > configuration failed for=20 package 'RODBC' >> > >> > The two header files are >> > present in my=20 box under /usr/local/include; I tried to symlink them to >> >=20 /usr/include and to /usr/local/lib/R/include to no avail. >> > >> >=20 Please help. >> > >> > Vittorio > >______________________________________________ >R-help@stat.math.ethz. ch mailing list >https://stat.ethz.ch/mailman/listinfo/r-help >PLEASE=20 do read the posting guide! http://www.R-project.org/posting-guide.html >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?18975192.1131545939684.JavaMail.root>