Re: compiling unixodbc support
Eddie <[email protected]>
| Newsgroups | gmane.comp.lang.4gl.aubit.general |
|---|---|
| Message-ID | <CAGJakskKBeQc8XrQvQnQ7GbLxJWnR6eGxuWX3nDGGB-+Y=7k9Q@mail.gmail.com> |
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