[R] Problems with RODBC

[Marc Schwartz]

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"))
> ************************


Tomasz,

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