Hi,
Does anyone ever setup a informix client on UNIX and access the backend
database that also on UNIX via ODBC?
I have difficulty in having it working...
Here is my steps taken for the setting up...
1. define DSN in odbc.ini and related parameters
2. set environment INFORMIXDIR, INFORMIXSERVER, ODBCINI
3. define SERVERNAME, NETTYPE, HOSTNAME, SERVICE in informix/etc/sqlhosts
4. define hosts and services in /etc
The product use is
7.22 UC2 (solaris) - informix online server
client SDK 2.30 (hp)
Odbc driver from Informix client SDK or odbc driver from intersolv [Both
are version 3.11]
The application is compiled with libodbc.sl but in odbc.ini the driver set
for the DSN is ivinf913.sl.
If the driver is set to libodbc.sl, I will encounter stack overflow...which
may end up REBOOTING the HPUX.
Any idea what is ivinf913.sl? I use it because it is stated in ODBCREL.TXT
that found in informix/release.
I also have capture the odbctrace info, but don't know how to interpret it.
Does anyone know where I could get help or reference to understand those
info?
Error msg: -1803 - S0001
- Having verify the sqlhosts file is ok.
If you have any suggestions or idea, please also copy me at
mwteng@tibcofinance.com
Thanks you in advance.
Regards
Meng Wah