From owner-freebsd-questions@FreeBSD.ORG Wed Nov 9 14:19:03 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3453D16A44A for ; Wed, 9 Nov 2005 14:19:03 +0000 (GMT) (envelope-from vdemart1@tin.it) Received: from vsmtp3.tin.it (vsmtp3alice.tin.it [212.216.176.143]) by mx1.FreeBSD.org (Postfix) with ESMTP id B6EDC43D48 for ; Wed, 9 Nov 2005 14:19:02 +0000 (GMT) (envelope-from vdemart1@tin.it) Received: from pswm15.cp.tin.it (212.216.176.81) by vsmtp3.tin.it (7.2.060.1) id 4371C09A00027DD9; Wed, 9 Nov 2005 15:18:55 +0100 Message-ID: <18975192.1131545939684.JavaMail.root@pswm15.cp.tin.it> Date: Wed, 9 Nov 2005 15:18:59 +0100 (GMT+01:00) From: Vittorio To: r-help@stat.math.ethz.ch Mime-Version: 1.0 Content-Type: text/plain;charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Originating-IP: 193.108.204.21 Cc: freebsd-questions@freebsd.org Subject: R: Re: [R] RODBC fails to build X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Vittorio List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 09 Nov 2005 14:19:04 -0000 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: >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 >