Hi,
I need to connect an Informix SE database from MS windows 2000 ODBC, the server is : Redhat Linux 8.0, Informix SE 7.25. The client tool is: Informix connect 2.7. When I use DBping application to connect to the server, always encounter below error message:
SQLSTATE = IX000
SQLCODE = -25596

************************************************** *******
The sqlhosts on the server:
/usr/informix7/etc/sqlhosts

#demo_on onipcshm on_hostname on_servername
local seipcpip LS10 sqlexec
remotedb sesoctcp LS10 sqlexecd
************************************************** ********
The environment variable for user Informix on the server:

LS10-~,2:16pm> env |grep INFOR
LS10_DB=INFORMIX
INFORMIXDIR=/usr/informix7
INFORMIXSERVER=remotedb
INFORMIXTERM=terminfo
INFORMIXSQLHOSTS=/usr/informix7/etc/sqlhosts
DBIF_TYPE=INFORMIXSE
************************************************** ********
/etc/services

# Local services
sqlexecd 1536/tcp # Informix service
************************************************** ********
LS10-/etc,2:18pm> hostname
LS10
LS10-/etc,2:20pm>
************************************************** ********
The configuration in the Iconnect "Native connect page"

username "informix"
password "password"
Informix server "remotedb"
Hostname "LS10"
service "sqlexecd"
Protocol "sesoctcp"
Database "data"
************************************************** ********
Also add the informix service in clilent PC C:\winnt\system32\drivers\etc\services:
sqlexecd 1536/tcp #Informix
************************************************** ********

Anybody has any idea with this problem?

Thanks
Levin

Hi Levin,

Please test in /etc/services the line of service do not be last.
Check many files "services" exist and check %INFORMIXDIR% in W2000.

Gustavo.

Hi,Gustavo
Thanks for your reply!
This is because the win2000 INFORMIXSERVER environment setup problem, I added this environment on win2000 ,then this error dispeared.
But after that another error code came in like:
sqlcode=-908

I searched the forum and found this error may related to the network/socket problem. I run: telnet 127.0.0.1 1536 on the server, it can connect, no problem. But if I run: telnet 192.168.1.4 1536, it display connection refused by the server. Seems the port 1536 is only listenning local host but not for network connection. How to deal this wierd problem?

Thanks!!
Levin