Re: unix odbc and informix datasource problem
kjuliff@gmail.com wrote:
> pksaras@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.
> >
> Can you post your SQLHOSTS file? I have mine working now.
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_PATHunset 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-1TRANSLATIONDLL=/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_servernamedemo_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
Also, I set ODBCINI=/opt/infromix/etc/odbc.ini but no joy... Thanks again, -Chris