Re: Problems with odbc-connection to informix-database

Modify your /etc/ld.so.conf to:

include /etc/ld.so.conf.d/*.conf
/opt/IBM/informix/lib/cli
/opt/IBM/informix/lib/esql
/opt/IBM/informix/lib


rerun ldconfig as root.


If it doesn't help following command should give you more debuging info:

LD_DEBUG=files isql sospos

Regards,
Petr Gebauer

On Wednesday 20 July 2011 12:38:06 Michael Blum wrote:
> Thank You for your fast response!
> 
> root@debian-testwebserver:~# ldd /opt/IBM/informix/lib/cli/libifcli.so
>          linux-gate.so.1 =>  (0xb7740000)
>          libifgls.so => not found
>          libifglx.so => not found
>          libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb746f000)
>          libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb7449000)
>          libdl.so.2 => /lib/i686/cmov/libdl.so.2 (0xb7445000)
>          libcrypt.so.1 => /lib/i686/cmov/libcrypt.so.1 (0xb7413000)
>          libpthread.so.0 => /lib/i686/cmov/libpthread.so.0 (0xb73fa000)
>          /lib/ld-linux.so.2 (0xb7741000)
> 
> root@debian-testwebserver:~# locate libifgls.so
> /opt/IBM/informix/lib/esql/libifgls.so
> root@debian-testwebserver:~# locate libifglx.so
> /opt/IBM/informix/lib/esql/libifglx.so
> 
> but my /etc/ld.so.conf says:
> 
> include /etc/ld.so.conf.d/*.conf
> include $INFORMIXDIR/lib/cli/*
> include $INFORMIXDIR/lib/esql/*
> include $INFORMIXDIR/lib/*
> 
> Why are the libraries not found?
> 
> 
> 
> best regards
> 
> Michael Blum
> 
> Am 20.07.2011 11:58, schrieb Nick Gorham:
> > On 20/07/11 10:36, Michael Blum wrote:
> >> Hello!
> >> 
> >> I am trying to establish an ODBC connection from a Debian squeeze 32
> >> Bit machine to an Informix-Database on a Windows 2003 Server. I've
> >> downloaded and installed the IBM Informix Client Software Development
> >> Kit (http://www-01.ibm.com/software/data/informix/developer-edition/)
> >> I also installed unixodbc via aptitude.
> >> 
> >> Then I followed this Manual step by step:
> >> http://www.unixodbc.org/doc/informix.html
> >> 
> >> When I try to establish a connection it says error:
> >> 
> >> root@debian-testwebserver:~# isql sospos
> >> [ISQL]ERROR: Could not SQLConnect
> >> 
> >> (sospos = database-name)
> >> 
> >> 
> >> The log says:
> >> [ODBC][5737][1311152787.710027][SQLConnect.c][1063]Can't open lib
> >> '/opt/IBM/informix/lib/cli/libifcli.so' : file not found
> >> 
> >> But the file is there!!
> > 
> > Most likely that there is a lib that lib needs thats not found, either
> > not there or not on the lib search path
> > 
> > Try
> > 
> > ldd /opt/IBM/informix/lib/cli/libifcli.so
> > 
> > And see what it shows.
> > 
> > If you do
> > 
> > isql -v DSN
> > 
> > it will display any errors on the output.
> 
> _______________________________________________
> unixODBC-dev mailing list
> [email protected]
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.


_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev