SEO

I tried to set up a satasource according to the suggested way (see
below)

Now when I test it I get an error.

It cannot find the informix driver, though it is there.

So it's there and the path to informix libraries is set in/etc/ld_conf
and I tried also setting to another driver in the lib/cli directory but
I still get the cannot find error.

I hope someone can help,

Kate


[root@kylie bin]# ./isql pic2 informix pw -v
[01000][unixODBC][Driver Manager]Can't open lib
'/usr/informix/lib/cli/iclis09b.
so' : /usr/informix/lib/cli/iclis09b.so: cannot open shared object
file: No such
file or directory


Set up as per example at http://www.unixodbc.org/doc/informix.html
[Informix]
Description=Informix IDS 2000
Driver=/usr/local/informix/lib/cli/libifcli.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.00
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y

7. Define you Informix DSNs in odbc.ini

[miecr]
Driver=Informix
Server=BARNET
Database=miecr
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/usr/local/informix/lib/esql/igo4a304.so

>Now when I test it I get an error.
>It cannot find the informix driver, though it is there.
>So it's there and the path to informix libraries is set in/etc/ld_conf
>and I tried also setting to another driver in the lib/cli directory but
>I still get the cannot find error.

Did you run /sbin/ldconfig after editing ld.so.conf?

>I hope someone can help,

We use the Informix driver with unixODBC.

>[root@kylie bin]# ./isql pic2 informix pw -v
>[01000][unixODBC][Driver Manager]Can't open lib
>'/usr/informix/lib/cli/iclis09b.
>so' : /usr/informix/lib/cli/iclis09b.so: cannot open shared object

What dies 'ldd /usr/informix/lib/cli/iclis09b.so' say?

Have you set the ODBCINI environment variable?

>Set up as per example at http://www.unixodbc.org/doc/informix.html

>7. Define you Informix DSNs in odbc.ini
>[miecr]
>Driver=Informix
>Server=BARNET
>Database=miecr
>CLIENT_LOCALE=en_us.8859-1
>DB_LOCALE=en_us.8859-1
>TRANSLATIONDLL=/usr/local/informix/lib/esql/igo4a304.so

>
> Did you run /sbin/ldconfig after editing ld.so.conf?

Yes.
>

> We use the Informix driver with unixODBC.

Can you give me a snippet of your odbc.ini file? Do you have IDS?
>

>
> What dies 'ldd /usr/informix/lib/cli/iclis09b.so' say?

ldd - v /usr/informix/lib/cli/iclis09b.so

[kcj@kylie etc]$ ldd -v /usr/X11R6/lib64/libSM.so.6
/usr/informix/lib/cli/iclis09b.so:
libdl.so.2 (GLIBC_2.2.5) => /lib64/libdl.so.2
libm.so.6 (GLIBC_2.2.5) => /lib64/tls/libm.so.6
libcrypt.so.1 (GLIBC_2.2.5) => /lib64/libcrypt.so.1
libc.so.6 (GLIBC_2.3) => /lib64/tls/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6
/usr/informix/lib/esql/libifgls.so:
libc.so.6 (GLIBC_2.3) => /lib64/tls/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6
/usr/informix/lib/esql/libifglx.so:
libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6
/lib64/tls/libm.so.6:
libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6
/lib64/libdl.so.2:
libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6
libc.so.6 (GLIBC_PRIVATE) => /lib64/tls/libc.so.6
ld-linux-x86-64.so.2 (GLIBC_PRIVATE) =>
/lib64/ld-linux-x86-64.s
o.2
/lib64/libcrypt.so.1:
libc.so.6 (GLIBC_2.2.5) => /lib64/tls/libc.so.6
/lib64/tls/libc.so.6:
ld-linux-x86-64.so.2 (GLIBC_2.2.5) =>
/lib64/ld-linux-x86-64.so.



> Have you set the ODBCINI environment variable?

Yes


> >Set up as per example at http://www.unixodbc.org/doc/informix.html
>

I did

Thankds for your help so far bust I am still stuck!

OK. I have installed sdk 32 bit and have set up my INFORMIXDIR to point
to where it is installed /usr/informix32/....

This is the contents of my odnbinst.ini file

[Informix]
Description=Informix IDS 2000
Driver=/usr/informix32/lib/cli/iclis09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.00
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y


and this of my odbc.ini file
[pic2]
Driver=Informix
Server=kylie
Database=pic2
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/usr/informix32/lib/esql/igo4a304.so


And now I get only
[root@kylie bin]# ./isql pic2
[ISQL]ERROR: Could not SQLConnect


No other error.

I followed the instructions in
http://www.unixodbc.org/doc/informix.html

So I'm not sure where I'm going wrong ....

Any help appreciated

> What version of unix ODBC DM are you using? Is it >= 2.2.11?

Yes it is


As enough
> error message is not provided...Are you getting something of "ERROR
> -11048: UNABLE TO LOAD TRANSLATION SHARED LIBRARY (DLL)" ..

No, there IS no error message. Just what I posted.

Kate



If so there is
> high possibility that you are hitting Informix ODBC defect 175992. Ask
> your Tech Support for the patch.
>
> There is workaround exist, while linking(your application) if you use
> libifgls.so library (i.e -lifgls) then you will not see this issue.
>
> Thanks & Regards
> -Shesh
>
>
>
>
> "kjuliff@gmail.com" <kjuliff@gmail.com>
> Sent by: informix-list-bounces@iiug.org
> 07/19/2006 02:51 AM
>
> To
> informix-list@iiug.org
> cc
>
> Subject
> Re: unix odbc and informix datasource problem
>
>
>
>
>
>
> OK. I have installed sdk 32 bit and have set up my INFORMIXDIR to point
> to where it is installed /usr/informix32/....
>
> This is the contents of my odnbinst.ini file
>
> [Informix]
> Description=Informix IDS 2000
> Driver=/usr/informix32/lib/cli/iclis09b.so
> APILevel=1
> ConnectFunctions=YYY
> DriverODBCVer=03.00
> FileUsage=0
> SQLLevel=1
> smProcessPerConnect=Y
>
>
> and this of my odbc.ini file
> [pic2]
> Driver=Informix
> Server=kylie
> Database=pic2
> CLIENT_LOCALE=en_us.8859-1
> DB_LOCALE=en_us.8859-1
> TRANSLATIONDLL=/usr/informix32/lib/esql/igo4a304.so
>
>
> And now I get only
> [root@kylie bin]# ./isql pic2
> [ISQL]ERROR: Could not SQLConnect
>
>
> No other error.
>
> I followed the instructions in
> http://www.unixodbc.org/doc/informix.html
>
> So I'm not sure where I'm going wrong ....
>
> Any help appreciated
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
> --=_alternative 00382AFA652571B0_=
> Content-Type: text/html
> X-Google-AttachSize: 2630
>
>
> <br><font size=2 face="sans-serif">What version of unix ODBC DM are you
> using? Is it &gt;= 2.2.11? As enough error message is not provided...Are
> you getting something of &nbsp;&quot;ERROR -11048: UNABLE TO LOAD TRANSLATION
> SHARED LIBRARY (DLL)&quot; ..If so there is high possibility that you are
> hitting Informix ODBC defect 175992. Ask your Tech Support for the patch.</font>
> <br>
> <br><font size=2 face="sans-serif">There is workaround exist, while linking(your
> application) if you use libifgls.so library (i.e -lifgls) then you will
> not see this issue.</font>
> <br>
> <br><font size=2 face="sans-serif">Thanks &amp; Regards<br>
> -Shesh</font>
> <br>
> <br>
> <br>
> <br>
> <table width=100%>
> <tr valign=top>
> <td width=40%><font size=1 face="sans-serif"><b>&quot;kjuliff@gmail.com&quot;
> &lt;kjuliff@gmail.com&gt;</b> </font>
> <br><font size=1 face="sans-serif">Sent by: informix-list-bounces@iiug.org</font>
> <p><font size=1 face="sans-serif">07/19/2006 02:51 AM</font>
> <td width=59%>
> <table width=100%>
> <tr valign=top>
> <td>
> <div align=right><font size=1 face="sans-serif">To</font></div>
> <td><font size=1 face="sans-serif">informix-list@iiug.org</font>
> <tr valign=top>
> <td>
> <div align=right><font size=1 face="sans-serif">cc</font></div>
> <td>
> <tr valign=top>
> <td>
> <div align=right><font size=1 face="sans-serif">Subject</font></div>
> <td><font size=1 face="sans-serif">Re: unix odbc and informix datasource
> problem</font></table>
> <br>
> <table>
> <tr valign=top>
> <td>
> <td></table>
> <br></table>
> <br>
> <br>
> <br><tt><font size=2>OK. I have installed sdk 32 bit and have set up my
> INFORMIXDIR to point<br>
> to where it is installed /usr/informix32/....<br>
> <br>
> This is the contents of my odnbinst.ini file<br>
> <br>
> [Informix]<br>
> Description=Informix IDS 2000<br>
> Driver=/usr/informix32/lib/cli/iclis09b.so<br>
> APILevel=1<br>
> ConnectFunctions=YYY<br>
> DriverODBCVer=03.00<br>
> FileUsage=0<br>
> SQLLevel=1<br>
> smProcessPerConnect=Y<br>
> <br>
> <br>
> and this of my odbc.ini file<br>
> [pic2]<br>
> Driver=Informix<br>
> Server=kylie<br>
> Database=pic2<br>
> CLIENT_LOCALE=en_us.8859-1<br>
> DB_LOCALE=en_us.8859-1<br>
> TRANSLATIONDLL=/usr/informix32/lib/esql/igo4a304.so<br>
> <br>
> <br>
> And now I get only<br>
> [root@kylie bin]# ./isql pic2<br>
> [ISQL]ERROR: Could not SQLConnect<br>
> <br>
> <br>
> No other error.<br>
> <br>
> I followed &nbsp;the instructions in<br>
> http://www.unixodbc.org/doc/informix.html<br>
> <br>
> So I'm not sure where I'm going wrong ....<br>
> <br>
> Any help appreciated<br>
> <br>
> _______________________________________________<br >
> Informix-list mailing list<br>
> Informix-list@iiug.org<br>
> http://www.iiug.org/mailman/listinfo/informix-list<br>
> </font></tt>
> <br>
> --=_alternative 00382AFA652571B0_=--

>> What version of unix ODBC DM are you using? Is it >= 2.2.11?
> Yes it is

We are using 2.2.11-19 without incident.

> As enough
>> error message is not provided...Are you getting something of "ERROR
>> -11048: UNABLE TO LOAD TRANSLATION SHARED LIBRARY (DLL)" ..
> No, there IS no error message. Just what I posted.

Did you try doing an isql -v {DSN} to see if you get more info.

For instance:
tyr:~ # isql miecr
[ISQL]ERROR: Could not SQLConnect
tyr:~ # isql -v miecr
[S1000][unixODBC][Informix][Informix ODBC Driver][Informix]Client host
or user root@TYR.morrison.iserv.net is not trusted by the server.
[ISQL]ERROR: Could not SQLConnect

> Did you try doing an isql -v {DSN} to see if you get more info.
>
then I get:


[unixODBC][Informix][Informix ODBC Driver]Data source name not found
and
no default driver specified.
[ISQL]ERROR: Could not SQLConnect
[root@kylie bin]#

On Wed, 2006-07-19 at 08:34 -0700, kjuliff@gmail.com wrote:
> > Did you try doing an isql -v {DSN} to see if you get more info.
> then I get:
> [unixODBC][Informix][Informix ODBC Driver]Data source name not found
> and
> no default driver specified.
> [ISQL]ERROR: Could not SQLConnect

Then I suspect you don't have the ODBCINI environment variable specified
correctly.

Now I get

[unixODBC][Informix][Informix ODBC Driver][Informix]Server kylie is not
l
isted as a dbserver name in sqlhosts


And I have ensured there are no white spaces in odbc.ini or
odbcinst.ini

Getting better. Now it's only

Client host or user root@localhost.localdomain is not trusted by the
server.