我在WINDOWS，用DbVisualize連接linux下INFORMIX7.31，8000 埠 ping server 也不通。
linux為redhat 5.6，防火墻已經關閉，本機用dbaccess可以進入資料庫的。
在服務器端配置如下:
cat /etc/services
sqlexec 9088/tcp # IBM Informix SQL Interface
sqlexec 9088/udp # IBM Informix SQL Interface
sqlexec-ssl 9089/tcp # IBM Informix SQL Interface - Encrypted
sqlexec-ssl 9089/udp # IBM Informix SQL Interface - Encrypted
informix 8000/tcp # informix services
cat /opt/informix/etc/sqlhosts
#demo_on onipcshm on_hostname on_servername
#demo_se seipcpip se_hostname sqlexec
online_pc onipcshm localhost informix
online_tcp onsoctcp localhost informix
cat /opt/informix/.bash_profile
INFORMIXDIR=/opt/informix;export INFORMIXDIR
INFORMIXSERVER=online_tcp;export INFORMIXSERVER
ONCONFIG=onconfig.pc;export ONCONFIG
TERMCAP=/opt/informix/etc/termcap;export TERMCAP
cat /opt/informix/etc/onconfig.std
SERVERNUM 0 # Unique id corresponding to a Dynamic Server instance
DBSERVERNAME online_pc # Name of default database server
DBSERVERALIASES online_tcp # List of alternate dbservernames
NETTYPE ipcshm,3,30,CPU # Configure poll thread(s) for nettype
NETTYPE soctcp,3,30,NET # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
netstat -apn|grep 8000
tcp 0 0 127.0.0.1:8000 0.0.0.0:* LISTEN 3340/oninit
tcp 0 0 127.0.0.1:8000 127.0.0.1:26645 ESTABLISHED 3340/oninit
tcp 0 0 127.0.0.1:26645 127.0.0.1:8000 ESTABLISHED 14739/dbaccess
uj5u.com熱心網友回復：
cat /opt/informix/etc/sqlhosts#demo_on onipcshm on_hostname on_servername
#demo_se seipcpip se_hostname sqlexec
online_pc onipcshm localhost informix
online_tcp onsoctcp localhost informix
localhost 代表 127.0.0.1
你該把 localhost 改為 informix 服務器IP地址, 重新啟動資料庫后，在連線試試
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/63860.html
標籤：Informix