esql连接数据库失败
dbaccess能够连到数据库
但是在esql中连接数据库失败
比如 下面这小段esql程序编译后运行会出现错误
程序：
#include
main(){
$WHENEVER ERROR STOP;
$database testdb;
$insert into t values(1,"aaa");
$close testdb;
}
错误如下：
Program stopped by WHENEVER STOP
sqlca:
sqlcode:-930
sqlerrm: 'linux40'
sqlerrp: ''
sqlerrd:
sqlerrd(1)=0
(2)=0
(3)=0
(4)=0
(5)=0
(6)=0
sqlwarn.sqlwarn0:
.sqlwarn1:
.sqlwarn2:
.sqlwarn3:
.sqlwarn4:
.sqlwarn5:
.sqlwarn6:
.sqlwarn7:
但是在esql中连接数据库失败
比如 下面这小段esql程序编译后运行会出现错误
程序：
#include
main(){
$WHENEVER ERROR STOP;
$database testdb;
$insert into t values(1,"aaa");
$close testdb;
}
错误如下：
Program stopped by WHENEVER STOP
sqlca:
sqlcode:-930
sqlerrm: 'linux40'
sqlerrp: ''
sqlerrd:
sqlerrd(1)=0
(2)=0
(3)=0
(4)=0
(5)=0
(6)=0
sqlwarn.sqlwarn0:
.sqlwarn1:
.sqlwarn2:
.sqlwarn3:
.sqlwarn4:
.sqlwarn5:
.sqlwarn6:
.sqlwarn7:
12同行回答
#include
main(){
EXEC SQL WHENEVER ERROR STOP;
EXEC SQL connect to "testdb";
EXEC SQL insert into t values(1,"aaa");
EXEC SQL disconnect current;
}
试试这样可以么收起
main(){
EXEC SQL WHENEVER ERROR STOP;
EXEC SQL connect to "testdb";
EXEC SQL insert into t values(1,"aaa");
EXEC SQL disconnect current;
}
试试这样可以么收起
浏览1368
是在本机上操作的么？看错误代码好象不是，那需要使用 testdb@your_server_name，来连接-930------------ ...gllysltj 发表于 2011-2-18 15:42
是本机 不是远程实例是在本机上操作的么？看错误代码好象不是，那需要使用 testdb@your_server_name，来连接
-930
------------ ...
gllysltj 发表于 2011-2-18 15:42
是本机 不是远程实例收起
浏览1529
浏览1512
bash-3.00$ finderr 930
-930 Cannot connect to database server servername.
The application is trying to access another computer system but failed.
Note the server name in the current statement. Ask your network
administrator and DBA to check that the network is operational and that
the particular database server is active. This message appears with
Version 6.0 and later.
-930 Cannot connect to remote host sitename.
IBM Informix STAR or IBM Informix NET is trying to access another computer
system but has failed. Note the site name in the current statement.
Contact your network administrator, and ask for a check that the
network is operational and that the particular site is active. This
message appears in database servers prior to Version 6.0.收起
-930 Cannot connect to database server servername.
The application is trying to access another computer system but failed.
Note the server name in the current statement. Ask your network
administrator and DBA to check that the network is operational and that
the particular database server is active. This message appears with
Version 6.0 and later.
-930 Cannot connect to remote host sitename.
IBM Informix STAR or IBM Informix NET is trying to access another computer
system but has failed. Note the site name in the current statement.
Contact your network administrator, and ask for a check that the
network is operational and that the particular site is active. This
message appears in database servers prior to Version 6.0.收起
浏览1558