unix odbc and informix datasource problem
kju...@gmail.com
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
Adam Tauno Williams
>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
kju...@gmail.com
>
> 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!
kju...@gmail.com
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
Sheshnarayan Agrawal
What version of unix ODBC DM are you using? Is it >= 2.2.11? As enough error message is not provided...Are you getting something of "ERROR -11048: UNABLE TO LOAD TRANSLATION SHARED LIBRARY (DLL)" ..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
| "kju...@gmail.com"
<kju...@gmail.com>
Sent by: informix-l...@iiug.org 07/19/2006 02:51 AM |
|
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
kju...@gmail.com
> 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
> --=_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 >= 2.2.11? As enough error message is not provided...Are
> you getting something of "ERROR -11048: UNABLE TO LOAD TRANSLATION
> SHARED LIBRARY (DLL)" ..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 & Regards<br>
> -Shesh</font>
> <br>
> <br>
> <br>
> <br>
> <table width=100%>
> <tr valign=top>
> <td width=40%><font size=1 face="sans-serif"><b>"kju...@gmail.com"
> <kju...@gmail.com></b> </font>
> <br><font size=1 face="sans-serif">Sent by: informix-l...@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">inform...@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 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>
> Inform...@iiug.org<br>
> http://www.iiug.org/mailman/listinfo/informix-list<br>
> </font></tt>
> <br>
> --=_alternative 00382AFA652571B0_=--
ad...@morrison-ind.com
> 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 ro...@TYR.morrison.iserv.net is not trusted by the server.
kju...@gmail.com
> Did you try doing an isql -v {DSN} to see if you get more info.
>
[unixODBC][Informix][Informix ODBC Driver]Data source name not found
and
no default driver specified.
[ISQL]ERROR: Could not SQLConnect
[root@kylie bin]#
Adam Tauno Williams
Then I suspect you don't have the ODBCINI environment variable specified
correctly.
kju...@gmail.com
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
kju...@gmail.com
Getting better. Now it's only
Client host or user ro...@localhost.localdomain is not trusted by the
server.
pks...@gmail.com
I have similar odbc.ini and odbcinst.ini files. I am getting the same
error as Kate.
I have the sdk v2.9 installed.
host1-d:/usr/informix/etc # isql -v asr
[IM002][unixODBC][Driver Manager]Data source name not found, and no
default driver specified
[ISQL]ERROR: Could not SQLConnect
What did you do to get around this error ?
I enabled the ODBCINI env variable for the "informix" user as
ODBCINI=/usr/informix/etc/odbc.ini
I have pasted my odbc.ini and odbcinst.ini below,
MY ODBCINST.INI
[ODBC Drivers]
IBM INFORMIX ODBC DRIVER=Installed
\n
[Informix]
Driver=/usr/informix/lib/cli/iclit09b.so
#Driver=/extra/informix/lib/cli/iclit09b.so
#Setup=/extra/informix/lib/cli/iclit09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y
My ODBC.INI
[asr]
Driver=Informix
Description=IBM INFORMIX ODBC DRIVER
Database=asr
LogonID=usrtest
pwd=usrtest
Servername=ids_server1
\n
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/usr/informix/lib/esql/igo4a304.so
\n
[ODBC]
;uncomment the below line for UNICODE connection
;UNICODE=UCS-4
\n
Trace=0
TraceFile=/tmp/odbctrace.out
Any help i greatly appreciated.
thanks
spk
kju...@gmail.com
pks...@gmail.com wrote:
> Hello Kate and ALL,
>
> I have similar odbc.ini and odbcinst.ini files. I am getting the same
> error as Kate.
> I have the sdk v2.9 installed.
>
sut...@gmail.com
I have the same problem, here's all my info:
Important variables:
[informix@iq-redhat3-1 cli]$ cat ~/.bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:/opt/informix/bin:$HOME/bin
INFORMIXDIR=/opt/informix
INFORMIXSERVER=QADB1.englab.local
LD_LIBRARY_PATH=${INFORMIXDIR}/lib:${INFORMIXDIR}/lib/cli:${INFORMIXDIR}/lib/esql
export PATH INFORMIXDIR INFORMIXSERVER LD_LIBRARY_PATH
unset USERNAME
[informix@iq-redhat3-1 cli]$ cat /opt/informix/etc/odbcinst.ini
;---------------------------------------------------------------------------
; IBM INFORMIX ODBC Sample File
;
; File: odbcinst.ini
;
;---------------------------------------------------------------------------
\n
[ODBC Drivers]
IBM INFORMIX ODBC DRIVER=Installed
\n
[IBM INFORMIX ODBC DRIVER]
Driver=/opt/informix/lib/cli/iclit09b.so
Setup=/opt/informix/lib/cli/iclit09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y
[informix@iq-redhat3-1 cli]$ cat /opt/informix/etc/odbc.ini
;---------------------------------------------------------------------------
; IBM INFORMIX ODBC Sample File
;
; File: odbc.ini
;
;---------------------------------------------------------------------------
\n
[ODBC Data Sources]
Infdrv1=IBM INFORMIX ODBC DRIVER
Infdrv2=IBM INFORMIX ODBC DRIVER
ids2000=IBM INFORMIX ODBC DRIVER
\n
;
; Define ODBC Database Driver's Below - Driver Configuration Section
;
[Infdrv1]
Driver=/opt/informix/lib/cli/iclit09b.so
Description=IBM INFORMIX ODBC DRIVER
Database=stores_demo
LogonID=odbc
pwd=odbc
Servername=ids_server1
\n
[Infdrv2]
Driver=/opt/informix/lib/cli/iclis09b.so
Description=IBM INFORMIX ODBC DRIVER
Database=stores_demo
LogonID=odbc
pwd=odbc
Servername=ids_server2
CursorBehavior=0
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/opt/informix/lib/esql/igo4a304.so
\n
[ids2000]
Driver=/opt/informix/lib/cli/iclit09b.so
Description=IBM INFORMIX ODBC DRIVER
;Database=stores_demo
LogonID=informix
pwd=informix
Servername=qadb1.englab.local
\n
[ODBC]
;uncomment the below line for UNICODE connection
;UNICODE=UCS-4
\n
Trace=1
TraceFile=/tmp/odbctrace.out
InstallDir=/opt/informix
[informix@iq-redhat3-1 cli]$ cat /opt/informix/etc/sqlhosts
#
************************************************************************
#
# IBM INC.
#
# PROPRIETARY DATA
#
# Licensed Material - Property Of IBM
#
# "Restricted Materials of IBM"
#
# IBM Informix Client SDK
#
# (c) Copyright IBM Corporation 2002. All rights reserved.
#
# Title: sqlhosts.demo
# Description:
# Default sqlhosts file for running demos.
#
#**************************************************************************
demo_on onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
QABD1.englab.local onsoctcp qadb1.englab.local 1544
-------------------------------------------
Libs & such:
[informix@iq-redhat3-1 cli]$ ldd /opt/informix/lib/cli/iclit09b.so
libifgls.so => /opt/informix/lib/esql/libifgls.so (0x00575000)
libifglx.so => /opt/informix/lib/esql/libifglx.so (0x00481000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00560000)
libc.so.6 => /lib/tls/libc.so.6 (0x00111000)
libm.so.6 => /lib/tls/libm.so.6 (0x0024a000)
libdl.so.2 => /lib/libdl.so.2 (0x009b2000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x00a3f000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x006b8000)
-----------------------------------------------------------
The error(s):
[informix@iq-redhat3-1 cli]$ isql -v ids2000
[IM002][unixODBC][Driver Manager]Data source name not found, and no
default driver specified
[ISQL]ERROR: Could not SQLConnect
[informix@iq-redhat3-1 cli]$ pwd
/opt/informix/demo/cli
[informix@iq-redhat3-1 cli]$ ./catalog ids2000
Using specified DSN : ids2000
ERROR: -11041: IM002 : [Informix][Informix ODBC Driver]Data source
name not found and no default driver specified.
Error in Step 1 -- SQLConnect failed
Exiting!!
[informix@iq-redhat3-1 cli]$
Thanks in advance for any assistance!
-Chris
sut...@gmail.com
Thanks again,
-Chris