Re: compiling unixodbc support
Eddie <[email protected]>
| Newsgroups | gmane.comp.lang.4gl.aubit.general |
|---|---|
| Message-ID | <CAGJaksmvcK1PvvBrie2GYKLFKXz3eXMw3D1rCjt5V3MHUT_vhw@mail.gmail.com> |
thanks for responding, removed libiodbc and a few files left behind in /usr/lib/libiodbc.* but it seems to be required when using --with-unixodbc=/usr/bin gcc -shared sql.o sqlex.o array.o sqlstates.o -o /home/aubit/sourcecode/aubit4glsrc/plugins-1.2_35/libSQL_iodbc.so -liodbc -L/usr/local/lib -L/usr/lib -L/usr/local/lib /usr/bin/ld: cannot find -liodbc collect2: ld returned 1 exit status gmake[2]: *** [/home/aubit/sourcecode/aubit4glsrc/plugins-1.2_35/libSQL_iodbc.so] Error 1 I can query SQL server with no problems using odbc from the CLI /usr/bin/isql -v mssql2005 +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> but aubit wont compile when adding odbc support On Tue, Jan 28, 2014 at 4:25 AM, Mike Aubury <[email protected]> wrote: > 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 <[email protected]> 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 >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss >> >> > ------------------------------------------------------------------------------ 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