關(guān)于esql/c問題，程序執(zhí)行連不上數(shù)據(jù)庫

ningth

大家好，

我使用 rhel 4.6 + informix 11.10【自帶sdk】 環(huán)境

環(huán)境變量
INFORMIXDIR=/home/informix
INFORMIXSERVER=jn_dbs
ONCONFIG=onconfig.jn
DBDATE=MDY4*
INFORMIXSQLHOSTS=/home/informix/etc/sqlhosts
export INFORMIXDIR INFORMIXSERVER ONCONFIG INFORMIXSQLHOSTS
INFORMIXC=gcc
INFORMIXCPP=g++
export INFORMIXC INFORMIXCPP

LD_LIBRARY_PATH=$INFORMIXDIR/libINFORMIXDIR/lib/esql
export LD_LIBRARY_PATH

數(shù)據(jù)庫設(shè)置：
sqlhost

Jn_dbs onipcshm 192.168.1.132 sqlexe
jn_dbs_tcp onsoctcp 192.168.1.132 sqlexec

onconfig.jn 部分文件如下
--rootdbs路徑、空間
　　ROOTNAME rootdbs # Root dbspace name
　　ROOTPATH /home/informix/dbs/rootdbs # Path for device containing root dbspace
　　ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
　　ROOTSIZE 100000 # Size of root dbspace (Kbytes)
　　
　　--物理日志的dbs空間，先用rootdbs的20M；
　　PHYSDBS rootdbs # Location (dbspace) of physical log
　　PHYSFILE 20000 # Physical log file size (Kbytes)
　　
　　--邏輯日志用默認(rèn)的
　　# Logical Log Configuration
　　
　　LOGFILES 6 # Number of logical log files
　　LOGSIZE 2000 # Logical log size (Kbytes)
　　
　　--把磁帶的東西都改成/dev/null
　　TAPEDEV /dev/null # Tape device path
　　TAPEBLK 32 # Tape block size (Kbytes)
　　TAPESIZE 10240 # Maximum amount of data to put on tape (Kbytes)
　　
　　# Log Archive Tape Device
　　
　　LTAPEDEV /dev/null # Log tape device path
　　LTAPEBLK 32 # Log tape block size (Kbytes)
　　LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)
　　
　　--配置數(shù)據(jù)庫服務(wù)器參數(shù)，根據(jù)自己機(jī)器配置的實(shí)際情況分配locks和buffers;
　　# System Configuration
SERVERNUM        0                # Unique id corresponding to a OnLine instance
DBSERVERNAME                jn_dbs                # Name of default database server
DBSERVERALIASES        jn_dbs_tcp                # List of alternate dbservernames
NETTYPE         ipcshm,1,8,CPU  # Configure poll thread(s) for nettype
NETTYPE         soctcp,1,8,CPU  # 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)


編譯沒問題

運(yùn)行時錯誤

錯誤信息：
** Insufficient host variables to store results.
** FILE: [tuxsql.ec] LINE: [84] TIME: Sat Dec 29 22:54:53 2007
** SQLCODE=[-329]
** ERRMSG:

ningth

-329    Database not found or no system permission.

The database you tried to open is not visible to the database server.
Check the spelling of the name. Possibly the database is located in a
different database server (or network system), and you have omitted to
specify the server name (or site name) with the database name. If you
are sure the database should exist just as you spelled it, your next
step depends on the database server you are using.

If you are using IBM Informix SE, the visible databases are directories
with names in the form dbname.dbs. You must be able to read from and
write to them. The database server looks first in the current working
directory and then in each directory named in the DBPATH environment
variable. The most common cause of this error is an incorrect setting
or no setting for the DBPATH environment variable.

If you are using IBM Informix Dynamic Server, IBM Informix Universal Server, or
IBM Informix OnLine Dynamic Server, the database does not exist as you spelled it.
In some environments, two or more instances of the database server can run at
once and each instance has its own collection of databases. For Version 6.0
and later, the value of the INFORMIXSERVER environment variable determines the
instance of the database server that you use. For Versions 5.1x and earlier,
the ONCONFIG environment variable points to the configuration file that
determines the instance. See your database server administrator if you think
you might be using the wrong instance.

If you are connected to a secondary database server, the database you tried
to open might exist, but is not logged. Databases are required to be logged
to be able to access them on secondary database servers.

ningth

數(shù)據(jù)庫權(quán)限為 DBA

相同用戶下可以dbaccess，可以操作
但是運(yùn)行程序就出現(xiàn) 329 錯誤，很是奇怪

請各位老大幫嗎

reneyangs

我也遇到同樣的問題，有高手幫忙看一下嗎？

wstar

看來搞Informix的高手真是不多了啊

liaosnet

不懂esql,米辦法~~

blackuhlan

可能方向：
A. EXEC SQL database :dbname; or EXEC SQL connect to :dbname;沒有調(diào)用或者dbname沒給對，調(diào)試一下，判斷這個語句的sqlca.sqlcode.
B. 程序不是你說的那個用戶下運(yùn)行的，或者程序的屬主不對,應(yīng)該和informix在同一個組，并且你這個用戶應(yīng)該有要操作的數(shù)據(jù)庫的dba（操作要用，如果僅僅是連接可以沒有）和connect權(quán)限。
C. 環(huán)境變量，可能性很小。

3sane

看樣子好像是TUXEDO的中間鍵環(huán)境，你先用esqldemo的程序調(diào)通了，記得TUXEDO有自己聯(lián)INFORMIX的函數(shù)庫的。

blackuhlan

樓主哪里提到用了tuxedo了，我怎么沒看見。如果是tuxedo的服務(wù)，你需要自己打開數(shù)據(jù)庫，例如再tuxedo的callback函數(shù)中加入連接數(shù)據(jù)庫的語句

dlms

權(quán)限的問題