Skip to content

Problems when installing RODBC in debian etch

16 messages · Dirk Eddelbuettel, Markus Jäntti, Griera +2 more

#
Hello:

I am tried to install the RODBC package in debian etch. At the end of the 
installation it appears errors:

**********************************************
* Installing *source* package 'RODBC' ...
checking for gcc... 
gcc -std=gnu99
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 for stdint.h... 
yes
checking for unistd.h... 
yes
checking sql.h usability... 
no
checking sql.h presence... 
no
checking for sql.h... 
no
checking sqlext.h usability... 
no
checking sqlext.h presence... 
no
checking for sqlext.h... 
no
configure: error: "ODBC headers sql.h and sqlext.h not found"
ERROR: configuration failed for package 'RODBC'
** Removing '/usr/local/lib/R/site-library/RODBC'
The downloaded packages are in
/tmp/RtmpOnB5P3/downloaded_packages
Warning message:
In install.packages(pkgs = c("RODBC"), lib 
= "/usr/local/lib/R/site-library", :
installation of package 'RODBC' had non-zero exit status

**********************************************

And the package is not installed. 
I am using the repositorios of:
        deb http://cran.cict.fr/bin/linux/debian etch-cran/
#
On 26 June 2008 at 16:20, griera at gmail.com wrote:
| Hello:
| 
| I am tried to install the RODBC package in debian etch. At the end of the 
| installation it appears errors:
[...]
| Somebody knows which is the problem and the solution?

Well this has been maintained as a package in Debian for years so I'd start with 

	sudo apt-get install r-cran-rodbc

If you still want to build locally, use the Build-Depends the package gives
you. 

Hth, Dirk
#
Hi,

You can either use Dirks package using

    apt-get install r-cran-rodbc

which will pull the needed libraries, or install a more recent version
from CRAN. For this you need the build dependencies which you can likely
get by

    apt-get build-dep r-cran-rodbc

provided you have a source entry in your /etc/apt/sources.list

Johannes

* griera at gmail.com <griera at gmail.com> [080626 16:30]:

  
    
#
To compile, you'd need a -dev package for the odbc package you are
using. However, you can instead just install the debian paclage
r-cran-rodbc.

markus
On Thu, 2008-06-26 at 16:20 +0200, griera at gmail.com wrote:

  
    
#
A Dijous 26 Juny 2008 16:52, Dirk Eddelbuettel va escriure:
Thanks a lot. I have installed the package without problems with this command. 
Regards.
#
Hello:

I have installed the package without problems with this order:

	$ sudo apt-get install r-cran-rodbc

but, when I tried to load it using library(RODBC) I get the following error:

	> library(RODBC) Error in Sys.localeconv()$decimal_point : 
	$ operator is invalid for atomic vectors 
	Error : .onLoad failed in 'loadNamespace' for 'RODBC' 
	Error: package/namespace load failed for 'RODBC'

What I'm doing wrong? Thanks a lot.
#
On 26 June 2008 at 18:14, griera at gmail.com wrote:
| Hello:
| 
| I have installed the package without problems with this order:
| 
| 	$ sudo apt-get install r-cran-rodbc
| 
| but, when I tried to load it using library(RODBC) I get the following error:
| 
| 	> library(RODBC) Error in Sys.localeconv()$decimal_point : 
| 	$ operator is invalid for atomic vectors 
| 	Error : .onLoad failed in 'loadNamespace' for 'RODBC' 
| 	Error: package/namespace load failed for 'RODBC'
| 
| What I'm doing wrong? Thanks a lot.

It looks like the package and your R version are out of sync.  What R version
are you using?  Did you get it from Debian like r-cran-rodbc ?

Dirk
#
Hi:

A Divendres 27 Juny 2008 04:14, Dirk Eddelbuettel va escriure:
error:
The version of the packages is:
	r-base-core 2.7.1-1~etchcran.0
	r-cran-rodbc 1.1.7-1 1.1.7-1
I have installed the package with the command:
	$ sudo apt-get install r-cran-rodbc
In the sources.list I have (in this order):
	deb http://cran.cict.fr/bin/linux/debian etch-cran/
	deb http://security.debian.org/ etch/updates main contrib non-free 
	deb http://ftp.fr.debian.org/debian/ etch main contrib non-free
This is OK?

Thanks a lot. G Riera
#
On 27 June 2008 at 08:28, griera at gmail.com wrote:
| Hi:
| 
| A Divendres 27 Juny 2008 04:14, Dirk Eddelbuettel va escriure:
| > On 26 June 2008 at 18:14, griera at gmail.com wrote:
| > | but, when I tried to load it using library(RODBC) I get the following 
| error:
| > | 	> library(RODBC) Error in Sys.localeconv()$decimal_point :
| > |
| > | 	$ operator is invalid for atomic vectors
| > | 	Error : .onLoad failed in 'loadNamespace' for 'RODBC'
| > | 	Error: package/namespace load failed for 'RODBC'
| > |
| > | What I'm doing wrong? Thanks a lot.
| >
| > It looks like the package and your R version are out of sync.  What R
| > version are you using?  Did you get it from Debian like r-cran-rodbc ?
| 
| The version of the packages is:
| 	r-base-core 2.7.1-1~etchcran.0
| 	r-cran-rodbc 1.1.7-1 1.1.7-1

Ah, yes, "it is our fault" -- you are using the new R via the CRAN repos
(which is the Right Thing if you want newer R).

But it turns out that that version is no longer compatible with the RODBC
version in Debian etch.  In Debian testing and unstable, we are at RODBC
1.2.3-1. 

| I have installed the package with the command:
| 	$ sudo apt-get install r-cran-rodbc
| In the sources.list I have (in this order):
| 	deb http://cran.cict.fr/bin/linux/debian etch-cran/
| 	deb http://security.debian.org/ etch/updates main contrib non-free 
| 	deb http://ftp.fr.debian.org/debian/ etch main contrib non-free
| This is OK?

It is, it is just that "we" are trying to help by offering a newer R, yet are
conflicting with the older RODBC.  

It really is a problem with the older Debian etch.  So you do need to rebuild
RODBC, either build your own r-cran-rodbc from sources (so you would take the
sources from current Debian and rebuild on your machine) or use R's
facilities -- whichever you are most familiar with.

| Thanks a lot. G Riera

Thanks for your patience, Dirk
#
Hi,

I just added RODBC to the list of packages maintained for the Debian
etch backports on CRAN. The r-cran-rodbc packages are on their way to
CRAN - if you want them now, you can use

    deb http://chem.uft.uni-bremen.de/r-cran etch-cran/

as an alternative.

Johannes

* Dirk Eddelbuettel <edd at debian.org> [080627 13:30]:

  
    
#
Johannes,
On 27 June 2008 at 17:05, Johannes Ranke wrote:
| Hi,
| 
| I just added RODBC to the list of packages maintained for the Debian
| etch backports on CRAN. The r-cran-rodbc packages are on their way to
| CRAN - if you want them now, you can use
| 
|     deb http://chem.uft.uni-bremen.de/r-cran etch-cran/
| 
| as an alternative.

Super -- thanks for the quick addition!

Depending on how much energy and time you have, you could try to establish
contact with the folks at backport.org so that other Debian users (who may
not know about the CRAN repos) could get it too.  Just a thought.

Cheers, Dirk
#
* Dirk Eddelbuettel <edd at debian.org> [080627 19:30]:
Yes - I would have to make the packages compatible to their policy and
need a Debian Developer to do the uploads.
 
Johannes
#
On 27 June 2008 at 21:46, Johannes Ranke wrote:
| * Dirk Eddelbuettel <edd at debian.org> [080627 19:30]:
| > 
| > Johannes,
| >
| > On 27 June 2008 at 17:05, Johannes Ranke wrote:
| > | Hi,
| > | 
| > | I just added RODBC to the list of packages maintained for the Debian
| > | etch backports on CRAN. The r-cran-rodbc packages are on their way to
| > | CRAN - if you want them now, you can use
| > | 
| > |     deb http://chem.uft.uni-bremen.de/r-cran etch-cran/
| > | 
| > | as an alternative.
| > 
| > Super -- thanks for the quick addition!
| > 
| > Depending on how much energy and time you have, you could try to establish
| > contact with the folks at backport.org so that other Debian users (who may
| > not know about the CRAN repos) could get it too.  Just a thought.
| 
| Yes - I would have to make the packages compatible to their policy and
| need a Debian Developer to do the uploads.

I see -- as backports.org is not 'officially' Debian I was hoping that it may
have a more lenient upload policy. Guess we'll make do with CRAN then. Could
you make sure the README reflects your package ports too?

Thanks again, Dirk
#
Le ven. 27 juin ? 11:05, Johannes Ranke a ?crit :
<Sigh :-> Did the same on Ubuntu i386. README update, too.

Vincent
#
* Vincent Goulet <vincent.goulet at act.ulaval.ca> [080628 00:20]:
Your're still ahead of me with ess, which I skipped until someone
complains...

Johannes
#
* Dirk Eddelbuettel <edd at debian.org> [080627 22:10]:
Sorry, I only updated the README, not the more visible README.html - now on its way.

Johannes