Re: [R] Problems with RODBC

From: Marc Schwartz <>
Date: Thu 27 Jul 2006 - 22:22:50 EST

On Thu, 2006-07-27 at 11:16 +0200, Tomasz Puzyn wrote:
> Dear Michael,
> I have a problem with RODBC installation. When I try to install it, I
> get the output following output. Give me some ideas, why I can not to do
> it properly?
> Regards,
> Tomasz
> ****************************
> * Installing *source* package 'RODBC' ...
> checking for gcc... gcc
> 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 whether we are using the GNU C compiler... yes
> checking whether gcc accepts -g... yes
> checking for gcc option to accept ANSI C... none needed
> checking how to run the C preprocessor... gcc -E
> checking for egrep... grep -E
> checking for ANSI C header files... yes
> checking for sys/types.h... yes
> checking for sys/stat.h... yes
> checking for stdlib.h... yes
> checking for string.h... yes
> checking for memory.h... yes
> checking for strings.h... yes
> checking for inttypes.h... yes
> 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/lib64/R/library/RODBC'
> The downloaded packages are in
> /tmp/RtmphYJYHP/downloaded_packages
> Warning message:
> installation of package 'RODBC' had non-zero exit status in:
> install.packages(c("RODBC"))
> ************************


You are missing the unixODBC header files, which are required to compile the package from source.

You did not indicate which Linux distribution you are using, but if you are on an RPM based distribution, you need to install 'unixODBC-devel'. It looks like Debian based distributions use 'unixodbc-devel' (Note lack of capitalization).

HTH, Marc Schwartz mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Thu Jul 27 22:27:07 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Fri 28 Jul 2006 - 00:17:34 EST.

Mailing list information is available at Please read the posting guide before posting to the list.