Re: [Aubit4gl-discuss] compiling unixodbc support

[Mike A. <mi...@au...>]

That looks like its the iodbc library thats broken - not the unixodbc (at
least - not at that point in time)

Try removing the libraries completely (especially iodbc if you're not using
it) - and reinstall unixodbc  ?




On 28 January 2014 03:20, Eddie <bre...@gm...> wrote:

> 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
> Aub...@li...
> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>
>