Oninit cdi / Archive
Talk to an expert →

unix odbc and informix datasource problem

Posted in 2006

Topics: Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Internationalization & Character Sets

kjuliff@gmail.com — — source: Usenet: comp.databases.informix

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-1TRANSLATIONDLL=/usr/local/informix/lib/esql/igo4a304.so

↪ replying to kjuliff@gmail.com
Adam Tauno Williams — — source: Usenet: comp.databases.informix

>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

↪ replying to Adam Tauno Williams
kjuliff@gmail.com — — source: Usenet: comp.databases.informix

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

Glossary