[Rd] unable to compile RODBC (R 2.9.2, AIX)

[Prof Brian Ripley]

On Sat, 31 Oct 2009, Chuck White wrote:

> Hello -- I am trying to compile (linker error, not compiler error) RODBC for R 2.9.2 on AIX 5.3 using gcc. I get the following error:
>
> gcc -maix64 -pthread -std=gnu99 -shared -Wl,-brtl -Wl,-G -Wl,-bexpall -Wl,-bnoentry -lc -L/usr/lib -L/usr/X
> 11R6/lib -L/usr/local/lib -L/opt/freeware/lib -L/opt/freeware/lib64 -o RODBC.so RODBC.o -lodbc -lm -L/usr/l
> ocal/builddir/lib -lR
> ld: 0711-738 ERROR: Input file /usr/lib/libodbc.so:
>        XCOFF32 object files are not allowed in 64-bit mode.
> collect2: ld returned 8 exit status
> gmake: *** [RODBC.so] Error 1
> ERROR: compilation failed for package 'RODBC'
>
> I would appreciate any help I can get in this regard.  Thanks.

It looks simple: apparently you have a 64-bit R and a 32-bit ODBC 
library (and that's not an R issue, and we don't have enough to go on 
-- the posting guide does ask for 'at a minimum' information for good 
reasons).

Surely /opt/freeware/lib64 should precede (and hence have priority 
over) /opt/freeware/lib?  We don't know what linker you built gcc with 
-- some are clever enough to select libraries of the right 
architecture on e.g. Solaris, but I believe we've seen this before on 
(not so recent) versions of AIX.

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595