急!!!window上,DbVisualize客户端连接INFORMIX7.31问题

o青蛙王子o 2019-03-08 10:04:41
我在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

...全文
269 点赞 收藏 1
写回复
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
ArthurCYChen 2019-04-22
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地址, 重新启动数据库后,在连线试试
回复
相关推荐
发帖
Informix
创建于2007-09-28

1183

社区成员

其他数据库开发 Informix
申请成为版主
帖子事件
创建了帖子
2019-03-08 10:04
社区公告
暂无公告