客户机连接数据库时报931错

wanghao163

在SCO UNIX系统下，数据库服务器为online 7.30,UNIX客户机装了informix 5.10
$informixdir/etc/sqlhosts为
online ontlitcp servername sqlexec
/etc/services中设为
sqlexec 9777/tcp
此时，客户机连接数据库成功;并且WINDOWS客户机也连接数据库成功。

后因工作需要，将服务名改为gjsqlexec,即
$informixdir/etc/sqlhosts为
online ontlitcp servername gjsqlexec
/etc/services中设为
gjsqlexec 9777/tcp
此时，服务器端连接数据库成功，WINDOWS客户机连接数据库也成功，但UNIX客户机端连接数据库失败，报931错。
-931    Cannot locate servicename service/tcp service in /etc/services.

The service noted is not listed in the network configuration file
/etc/services (UNIX) or \etc\services (DOS). Check the
$INFORMIXDIR/etc/sqlhosts file and make sure that the service
name for the desired server is correct. If so, contact your network
administrator and find out why the service is not known. If you are
using INFORMIX-OnLine for NetWare, check the \etc\services file
on the client for the required entries.

将服务名改回sqlexec，则连接又正常了，为什么？

satoni

sqlhosts文件也要改撒

Bread2003

提示已经很清楚了,
The service noted is not listed in the network configuration file
/etc/services (UNIX) or \etc\services (DOS). Check the
$INFORMIXDIR/etc/sqlhosts file and make sure that the service
name for the desired server is correct.
可能你书写时有错误,重新该回来试试,注意Tab键分隔

wanghao163

satoni:sqlhosts文件肯定也改了。
Bread2003:语法肯定没错。

没办法，只能用服务名sqlexec了。
推论：informix online 5.10 的 star 只认服务名sqlexec。