[egenix-users] egenix does not find unixodbc library

[M.-A. Lemburg]

BALTUS Jean wrote:
> Hi all,
> 
>  
> 
> I've an Ubuntu 6.06, Zope 2.9.4 with python 2.4.3 UCS 4, freetds 0.61
> (source) and unixodbc 2.2.5 (source).
> 
>  
> 
> The zope process runs under user 'tony'.
> 
> I've set the owner of the freetds and unixodbc files to this same user.
> 
>  
> 
> I'm able to connect to our database with isql or tsql.
> 
>  
> 
> I've  installed the correct egenix mxodbc-zopeda version and get the
> following message when zope starts:
> 
>  
> 
> eGenix mxODBC Zope DA: trying iODBC interface... failed: libiodbc.so.2:
> cannot open shared object file: No such file or directory
> 
> eGenix mxODBC Zope DA: trying unixODBC interface... failed:
> libodbc.so.1: cannot open shared object file: No such file or directory
> 
> eGenix mxODBC Zope DA: No usable mxODBC subpackages found.
> 
>  
> 
> The file libodbc.so.1 exists but egenix does not find it. Do I have to
> set up something?

It is possible that the linker doesn't know about the file:

ldconfig -p

should list it.

Note that it's also possible that libodbc.so.1 requires another
library that the linker doesn't find. Try running ldd /path/to/libodbc.so.1
as the user you run Zope under. It should print out a list of libs such
as (the example output is from a 64-bit SuSE system):

        libdl.so.2 => /lib64/libdl.so.2 (0x0000002a956e0000)
        libpthread.so.0 => /lib64/tls/libpthread.so.0 (0x0000002a957e3000)
        libc.so.6 => /lib64/tls/libc.so.6 (0x0000002a958f8000)
        /lib64/ld-linux-x86-64.so.2 => /lib64/ld-linux-x86-64.so.2
(0x000000552aaaa000)

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Oct 02 2006)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::