Re: compiling unixodbc support
Mike Aubury <[email protected]>
| Newsgroups | gmane.comp.lang.4gl.aubit.general |
|---|---|
| Message-ID | <CAGAq4WEKsUrw3SrOD=n3A7MOoZu6BJQBy_DH9gjhwEeqHe6Pkg@mail.gmail.com> |
Did you rerun the ./configure ? What about --with-iodbc=no or --without-iodbc ? On 28 January 2014 14:40, Eddie <[email protected]> wrote: > > 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 > > ------------------------------------------------------------------------------ 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