compiling unixodbc support

Hi all,


Trying to compile unixodbc support to query tables in MS SQLSERVER from 4gl
modules but getting an error:



./configure --prefix=/home/aubit/aubit4gl --with-informix=/home/informix
--with-pgsql=no --with-pdf=/usr/local/bin --with-unixodbc=/usr/bin


gcc -shared sql.o sqlex.o array.o sqlstates.o -o
/home/aubit/sourcecode/aubit4gl
src/plugins-1.2_35/libSQL_iodbc.so -liodbc -L/usr/local/lib -L/usr/lib
-L/usr/lo
cal/lib
/usr/bin/ld: skipping incompatible /usr/lib/libiodbc.so when searching for
-liod
bc
/usr/bin/ld: /usr/lib/libiodbc.a(catalog.o): relocation R_X86_64_32 against
`iod
bcdm_global_lock' can not be used when making a shared object; recompile
with -f
PIC
/usr/lib/libiodbc.a: could not read symbols: Bad value
collect2: ld returned 1 exit status
gmake[2]: ***
[/home/aubit/sourcecode/aubit4glsrc/plugins-1.2_35/libSQL_iodbc.so
] Error 1
gmake[2]: Leaving directory
`/home/aubit/sourcecode/aubit4glsrc/lib/libsql/odbc'
gmake[1]: ***
[/home/aubit/sourcecode/aubit4glsrc/plugins-1.2_35/libSQL_iodbc.so
] Error 2
gmake[1]: Leaving directory `/home/aubit/sourcecode/aubit4glsrc/lib'
make: *** [corecompile] Error 2



rpm -qa |grep -i odbc
unixODBC-2.2.11-10.el5
unixODBC-libs-2.2.11-10.el5
libiodbc-devel-3.52.7-1.el5
unixODBC-libs-2.2.11-10.el5
unixODBC-devel-2.2.11-10.el5
libiodbc-3.52.7-1.el5
unixODBC-2.2.11-10.el5
unixODBC-devel-2.2.11-10.el5
libiodbc-devel-3.52.7-1.el5
libiodbc-3.52.7-1.el5




Seems to be some misconfiguration between 32 and 64 bit libraries.





environment


export AUBITDIR=/home/aubit/aubit4glsrc
export AUBITDIR_SRC=/home/aubit/aubit4glsrc
export A4GL_INIFILE=/home/aubit/aubit4glsrc/etc/aubitrc
export AWK=gawk
export DBSCREENOUT=/tmp/${USER}.out
export A4GL_PRINTSCRKEY=CONTROL-P
export A4GL_PRINTSCRFILE=+$DBSCREENOUT
export ODDOPTIONS=N
export FORCE_CLOSE=Y
export BINDDBDATE=Y
export CACHESCHEMA=Y
export DATE_AS_CHAR=Y
export NO_UPDATE_TABLE=Y
export FIXUPDATE=Y
export A4GL_SQLTYPE=esql
export DBDATE=DMY4/
#export SQLUID=xxx
#export SQLPWD=yyy
#export PATH=$PATH:/home/aubit/aubit4glsrc/bin:/usr/local/unixODBC/bin
export PATH=$PATH:/home/aubit/aubit4glsrc/bin
export NODATETIMES=Y
export A4GL_ALLOWCOMMAINDECIMAL=Y
export LOGODBCSQL=N
export A4GL_NUMERIC=,.
export DATE_AS_ISO_DATE_STRING=Y
export USEREALTABLEFORREP=Y
#export
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/unixODBC/lib:/lib:/lib/esql:/usr/local/lib:/home/aubit/aubit4glsrc/lib
export
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/lib/esql:/usr/local/lib:/home/aubit/aubit4glsrc/lib


 cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.5 (Tikanga)

uname -a
Linux localhost 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT
 2010 x86_64 x86_64 x86_64 GNU/Linux



How can I troubleshoot this problem?

------------------------------------------------------------------------------
WatchGuard Dimension instantly turns raw network data into actionable 
security intelligence. It gives you real-time visual feedback on key
security issues and trends.  Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk

_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss