R SIG Debian - Jun 2008 - Problems when installing RODBC in debian etch

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/
From the debian official repositorios I have installed the package:
        odbcinst1debian1
I have the same problem if instead of odbcinst1debian1 I install unixodbc

Somebody knows which is the problem and the solution?

Thank you for your help 

G Riera

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

-- 
Three out of two people have difficulties with fractions.

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]:
> 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/
> >From the debian official repositorios I have installed the package:
>         odbcinst1debian1
> I have the same problem if instead of odbcinst1debian1 I install unixodbc
> 
> Somebody knows which is the problem and the solution?
> 
> Thank you for your help 
> 
> G Riera
> 
> _______________________________________________
> R-SIG-Debian mailing list
> R-SIG-Debian at r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-debian
-- 
Dr. Johannes Ranke                 jranke at uni-bremen.de
Brahmsstr. 4                       D-28209 Bremen
ab 1.8.2008: Kronacherstr. 8,      D-79639 Grenzach-Wyhlen

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:
> 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/
> >From the debian official repositorios I have installed the package:
>         odbcinst1debian1
> I have the same problem if instead of odbcinst1debian1 I install unixodbc
> 
> Somebody knows which is the problem and the solution?
> 
> Thank you for your help 
> 
> G Riera
> 
> _______________________________________________
> R-SIG-Debian mailing list
> R-SIG-Debian at r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-debian
-- 
Markus Jantti
Abo Akademi University
mjantti at abo.fi
http://www.iki.fi/~mjantti

* 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.
 
Johannes