[R-sig-DB] Error: package 'RODBC' was built before R 3.0.0: please re-install it

[Edward Vanden Berghe]

I've had warnings about missing header files while installing other
packages, and the solution was to install development versions of software R
depends on, rather than the 'normal', default version of that software.
Missing header files would make compilation of the package fail, and make
the installation exit with non-zero exit status.

Not sure which application should be providing the missing header files
listed below (sql.h, sqlext.h); did you install ODBC as a separate linux
application through apt-get?

Are you sure you need ODBC? I have very good experience with the combination
of DBI and, for my set-up, RPostgreSQL; there are packages for other major
db engines as well. ODBC works like a charm on Windows, but I found it
fiddly on Ubuntu.

Edward

-----Original Message-----
From: r-sig-db-bounces using r-project.org [mailto:r-sig-db-bounces using r-project.org]
On Behalf Of Dirk Eddelbuettel
Sent: Thursday, February 27, 2014 15:56 PM
To: Luis Ridao
Cc: r-sig-db using r-project.org; Dirk Eddelbuettel
Subject: Re: [R-sig-DB] Error: package 'RODBC' was built before R 3.0.0:
please re-install it


On 27 February 2014 at 14:09, Luis Ridao wrote:
| 
| I'm trying to install the RODBC on Ubuntu 12.04 (64 bits)

Just do this in a terminal / at a command-prompt:

     sudo apt-get install r-cran-rodb

Dirk

| By doing within R:
| 
| > install.packages('RODBC')
| configure: error: "ODBC headers sql.h and sqlext.h not found"
| ERROR: configuration failed for package ?RODBC?
| * removing ?/home/luisr/R/x86_64-pc-linux-gnu-library/3.0/RODBC?
| 
| The downloaded source packages are in
|     ?/tmp/Rtmp6uZtxC/downloaded_packages?
| Warning message:
| In install.packages("RODBC") :
|   installation of package ?RODBC? had non-zero exit status
| 
| by doing outside R:
| 
| > sudo apt-get install r-cran-rodbc
| 
| it works but back in R i get this message:
| 
| > library(RODBC)
| Error: package ?RODBC? was built before R 3.0.0: please re-install it
| 
| 
| Can anyone help?
| 
| best,
| Luis

--
Dirk Eddelbuettel | edd using debian.org | http://dirk.eddelbuettel.com

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group R-sig-DB using r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db