[R] problem with RODBC installation

[Peter Dalgaard]

On 11/04/2010 08:14 AM, Jørgen Blystad Houge wrote:
...
>     '/tmp/Rtmpgb1Nxz/downloaded_packages'
> Warning message:
> In install.packages("RODBC") :
>   installation of package 'RODBC' had non-zero exit status
> 
> I found some info on it here:
> http://r.789695.n4.nabble.com/Problem-installing-RODBC-td2016736.html but
> how should I use it???
> 
> (Yes, I am very novice to Linux (and R) so it might be a stupid
> question....)


Well, the answer is in the output:

> configure: error: "ODBC headers sql.h and sqlext.h not found"

That's an installation issue with ODBC, not an R issue as such. Usually
a development package is missing, but exactly which one depends on your
particular flavour of Linux. In Fedora 13, it is here:

$ rpm -qf /usr/include/sqlext.h
unixODBC-devel-2.2.14-12.fc13.i686

so the unixODBC-devel package is required. In e.g. Ubuntu, it is -er-
somewhere else...

-- 
Peter Dalgaard
Center for Statistics, Copenhagen Business School
Phone: (+45)38153501
Email: pd.mes at cbs.dk  Priv: PDalgd at gmail.com