Re: compiling unixodbc support
Mike Aubury <[email protected]>
| Newsgroups | gmane.comp.lang.4gl.aubit.general |
|---|---|
| Message-ID | <CAGAq4WF2thDDsz_4oHwaK4B+LuF4bAYKPr07h62+_s1aULRfTg@mail.gmail.com> |
Do you have a "libSQL_unixodbc.so" in the plugins directory ? (--with-unixodbc=/usr/bin looks wrong so it might not be detecting unixodbc properly) On 28 January 2014 15:26, Eddie <[email protected]> wrote: > > > > adding --with-iodbc=no got it to compile but adbacces fails to open when > using type=odbc > > > ADBACCESS: Query-language Error: can't open DLL > /home/aubit/aubit4gl/plugins-1 > .2_28/libSQL_unixodbc.so - STOP > Error msg: > /home/aubit/aubit4gl/plugins-1.2_28/li > bSQL_unixodbc.so: cannot open shared object file: No such file or > directory---- > > > > ./configure --prefix=/home/aubit/aubit4gl --with- > informix=/home/informix --with-pgsql=no --with-pdf=/usr/local/bin > --with-unixodb > c=/usr/bin --with-iodbc=no > > Aubit 4gl compiler is working - compiler build was successfull. > > > > > Im using unixODBC from yum repository so Im using /usr/bin for the path in > the configure command > > Installed Packages > unixODBC.i386 2.2.11-10.el5 installed > unixODBC.x86_64 2.2.11-10.el5 installed > unixODBC-devel.i386 2.2.11-10.el5 installed > unixODBC-devel.x86_64 2.2.11-10.el5 installed > unixODBC-libs.i386 2.2.11-10.el5 installed > unixODBC-libs.x86_64 2.2.11-10.el5 installed > > > > > > > > > On Tue, Jan 28, 2014 at 10:59 AM, Mike Aubury <[email protected]> wrote: > >> 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 > > ------------------------------------------------------------------------------ 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