精华区文章阅读

发信人: chengkai.bbs@bbs.sjtu.edu.cn (垃圾桶), 信区: cndatabase
标  题: informix的问题，HELP ME
发信站: 饮水思源站 (Sat Sep 20 03:29:02 1997)
转信站: Lilac!ustcnews!ustcnews!sjtunews!sjtubbs
出  处: bbs.sjtu.edu.cn

SERVER 配置
SCO OPENSERVER 3.0  环境下
  INFORMIX ONLINE 5.03
  INFORMIX STAR   5.03

  /ETC/HOST
   201.0.0.98  SERVER
   201.0.0.12  CHPC

  /ETC/SERVICES
   SQLEXEC    17008/TCP

  /ETC/RC2
   INFORMIXDIR=/usr/informix
   export INFORMIXDIR
   SQLEXEC=/usr/informix/lib/sqlexec
   export SQLEXEC
   /usr/informix/bin/tbinit
   /usr/informix/lib/sqlturbo

client 配置
SCO UNIX 3.2V4.2 AND TCP/IP RUNTIME
  INFORMIX NET 5.03
  INFORMIX ESQLC 5.03
  应用程序

  /ETC/HOST
    201.0.0.98 SERVER
    201.0.0.12 CHPC

  /ETC/SERVICES
    SQLEXEC   17008/TCP

  /ETC/RC2
    INFORMIXDIR=/usr/informix
    export INFORMIXDIR
    SQLEXEC=/usr/informix/lib/sqlexec
    export SQLEXEC
    /usr/informix/lib/sqlexecd

  我在 client 端写了一个小程序
     #include<stdio.h>
     $include sqlca;
     $include sqlda;
     $include sqltypes;

     main()
     {
       $database jh@server;
       if (sqlca.sqlcode!=0) then
        {
          printf("error code %d\n",sqlca.sqlcode);
  exit();
        }
     }
  运行后
     error code 354
但此程序在SERVER上运行正常。

     #include<stdio.h>
     $include sqlca;
     $include sqlda;
     $include sqltypes;

     main()
     {
       $create database aaa@server;
       if (sqlca.sqlcode!=0) then
        {
          printf("error code %d\n",sqlca.sqlcode);
  exit();
        }
     }
  运行后
     error code 554
但此程序在SERVER上运行正常。

   请问设置有何不对，CLIENT端如只装IFORRMIX NET
如何才能连上SERVER，另外我们购买的INFORMIX NET FOR SCO UNIX
RM 方式为什么没有 SOCTCP 的程序。

   另外，请问两台SERVER 都装ONLINE 和STAR 如何才能相互访问，互相读写，
怎样设置才不会出现锁错误，或一台SQLEXEC refuse connetion (errcode+25506)。

-354 Incorrect database or cursor name format.

This statement contains the name of a database or a cursor in some
improper format. If the statement is part of a program, the name
may have been passed in a host variable. Database names should be
no longer than 18 characters for OnLine and no longer than 10
characters for INFORMIX-SE (less in some host operating systems).
Cursor names must not exceed 18 characters.

Both database and cursor names must begin with a letter and
contain only letters, numbers, and underscore characters. Starting
with Version 6.0, database and cursor names can begin with an
underscore.

In DOS systems, file names can be a maximum of 8 characters plus a
3-character extension.

25506 The sqlexecd daemon cannot accept a connection on the socket.

Check that your TCP/IP network is installed and functioning
properly throughout the network.

-554 Syntax disallowed in this database server.

This statement or some clause in it is not supported by the database
server you are using. The database server in use is chosen when a
program starts based on the SQLEXEC environment variable (for
database server versions prior to 6.0). There are several small
differences in statement syntax between Informix database servers.
For example, the CREATE TABLE statement with OnLine supports
the clause IN dbspace (no quote characters used) while other database
servers support the clause  IN "pathname" (quotes required).

--
※ 来源:·饮水思源站 bbs.sjtu.edu.cn·[FROM: nobody]

Database 版 (精华区)