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

From: Marc Schwartz <>
Date: Sat, 31 Oct 2009 15:13:40 -0500

On Oct 31, 2009, at 1:13 PM, 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.o -lodbc -lm -L/usr/l
> ocal/builddir/lib -lR
> ld: 0711-738 ERROR: Input file /usr/lib/
> XCOFF32 object files are not allowed in 64-bit mode.
> collect2: ld returned 8 exit status
> gmake: *** [] Error 1
> ERROR: compilation failed for package 'RODBC'
> I would appreciate any help I can get in this regard. Thanks.

I don't have hands-on experience with AIX, but I am going to guess that you have a 32 bit version of unixODBC installed and that is what is being found on your system, raising the error. If you do have a 64 bit version installed, I believe that the path is /usr/lib64, rather than /usr/lib. So you perhaps need to adjust the library paths for the RODBC package configuration and/or if not yet installed, be sure to install a 64 bit version of unixODBC.

Additional information is available in the RODBC package vignette, which is available online:

See Appendix A for Installation information.

BTW, for future reference, you might want to post to the R-sig-db list:

HTH, Marc Schwartz mailing list Received on Sat 31 Oct 2009 - 20:16:18 GMT

This archive was generated by hypermail 2.2.0 : Mon 02 Nov 2009 - 02:30:20 GMT