急问sql语句问题！！！！！！

PICC

ifx 9.4版本
dbaccess dbname <<!

select * from dbname@informixservername:tablename
显示出错了：

  908: Attempt to connect to database server (informixservername, conerr=-25555, oserr=0)
failed.
但是在另外一台同样的机器上是可以有结果出来的。
到底是informix那个地方配置出了问题，请高手指点啊！！！

ps：select * from dbname:tablename是可以执行出来的。

wolfop

-25555  Server server-name is not listed as a dbserver name in sqlhosts.

The database server name that is mentioned in the current command is
not listed in the sqlhosts file. Check the server name for accuracy.
Check that all database servers to be accessed are included in the
sqlhosts file.

If you are using IBM Informix SE, your current working directory might be
an NFS-mounted directory. Change your current working directory to a
local directory, or add appropriate local directories to your DBPATH.

PICC

补充：sql中指定的informixservername是本地的ifx server来的。所以不存在网络的问题和信任机制的问题

PICC

sqlhosts文件肯定写了servername的，我直接用：
dbaccess dbname@server-name <<!
是没有问题的。现在主要是在sql语句中指定dbname@server-name就不行了。

原帖由 "wolfop" 发表：
-25555  Server server-name is not listed as a dbserver name in sqlhosts.

The database server name that is mentioned in the current command is
not listed in the sqlhosts file. Check the server name..........

zoukunhong

select * from dbname@informixservername:tablename
不能访问带日志的数据库,只能先connect该数据库,然后再select.

rock_jq

9.3 和 7。31 为什么可以啊

zoukunhong

我这边7.31不可,不过是从sco访问saloris

fengdana

我测试了一下,是可以的,我的版本是,9.3