headers
Michael Blum | 20 Jul 2011 11:36
Picon
Favicon

Problems with odbc-connection to informix-database

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 <at> 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!!

root <at> debian-testwebserver:~# locate libifcli.so
/opt/IBM/informix/lib/cli/libifcli.so

Full log here:
http://pastebin.com/t4pXME8g
(Continue reading)

Permalink | Reply |
headers
Nick Gorham | 20 Jul 2011 11:58
Favicon

Re: Problems with odbc-connection to informix-database

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 <at> 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
(Continue reading)

Permalink | Reply |
headers
Michael Blum | 20 Jul 2011 12:38
Picon
Favicon

Re: Problems with odbc-connection to informix-database

Thank You for your fast response!

root <at> 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 <at> debian-testwebserver:~# locate libifgls.so
/opt/IBM/informix/lib/esql/libifgls.so
root <at> 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
(Continue reading)

Permalink | Reply |
headers
Nick Gorham | 20 Jul 2011 12:44
Favicon

Re: Problems with odbc-connection to informix-database

On 20/07/11 11:38, Michael Blum wrote:
> Thank You for your fast response!
>
> root <at> 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 <at> debian-testwebserver:~# locate libifgls.so
> /opt/IBM/informix/lib/esql/libifgls.so
> root <at> 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?
>

Well strictly speaking that would be a question between yourself and
(Continue reading)

Permalink | Reply |
headers
Petr Gebauer | 20 Jul 2011 12:51
Favicon

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 <at> 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)
>
(Continue reading)

Permalink | Reply |
headers
Michael Blum | 20 Jul 2011 14:00
Picon
Favicon

Re: Problems with odbc-connection to informix-database

That's it!
Thank You very much!!

root <at> debian-testwebserver:~# isql -v sospos
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

Am 20.07.2011 12:51, schrieb Petr Gebauer:
> 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
>
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev <at> mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
Permalink | Reply |

Gmane