PB8.0 连接到 Informix 数据库

liu_cj

我要用 PB8.0 连接到 Informix 数据库,
dataserver:/informix>;onstat -
Informix Dynamic Server Version 7.31.UC4

我是按connection 里的填的,可是连不上数据库,不知是什么原因,请教各位高手了.

// Profile br
SQLCA.DBMS = "IN9 INFORMIX-9"
SQLCA.Database = "tock"    --------库名
SQLCA.UserId = "lih"       --------用户名
SQLCA.DBPass = <******>;   
SQLCA.ServerName = "hostserver@dataserver"     -----主机名 / 数据库服务名
SQLCA.AutoCommit = False
SQLCA.DBParm = "INET_DBPATH='c:\informix',INET_PROTOCOL='onsoctcp',INET_SERVICE='8170',Async=1"

horse

关注。。。。。。

glz

装INFORMIX 客户段,通过ODBC联不行吗

bybt

你有没有装PB DATADIRECT或Informix Connection？

liu_cj

我装有客户端的, 可以用Netterm 连上的.
PB 里有 Informix Connection , 应是可以在PB 里连接的
我的PB里也有 Informix Connection IN9
我的主机上的informix版本是
Informix Dynamic Server Version 7.31.UD2

我连接时出现-930的错误,
onbra20a:/home/liucj>;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.

LIOUBIN

// Profile INFORMIX
SQLCA.DBMS = "IN9 INFORMIX-9"
SQLCA.Database = "/c01/main/dev"
SQLCA.UserId = "用户名"
SQLCA.DBPass = <***********>;
SQLCA.ServerName = "192.168.1.100@数据库名l"
SQLCA.AutoCommit = False
SQLCA.DBParm = "INET_PROTOCOL='sesoctcp',INET_SERVICE='1526',INET_DBPATH='/c01/main/dev.dbs'"

我的这样已经连接成功了.  
如不成功EMAIL:LIUBIN@ROCK-WALL.COM

liu_cj

首先,谢谢各位, 但还是不行:
现在的配置是:
出现: error -255  Not in transaction.

　　// Profile br
SQLCA.DBMS = "IN9 INFORMIX-9"
SQLCA.Database = "tock@pbdata"
SQLCA.UserId = "lih"
SQLCA.DBPass = <******>;
SQLCA.ServerName = "192.2.1.250@pbdata"
SQLCA.AutoCommit = False
SQLCA.DBParm = ",INET_DBPATH='tock@pbdata',INET_PROTOCOL='onsoctcp',INET_SERVICE='8170'"

pbdata:/informix>;finderr -255
-255    Not in transaction.
The database server cannot execute this COMMIT WORK or ROLLBACK WORK
statement because no BEGIN WORK was executed to start a transaction.
Because no transaction was started, you cannot end one. Any database
modifications that were made are now permanent; they cannot be rolled
back but do not need to be committed. Review the sequence of SQL
statements to see where the transaction should have started.
This error can occur when you open a cursor for update and have not started
a transaction yet.

LIOUBIN

请加上数据库路径;
SQLCA.Database = "数据库路径及名称不要加扩展名"

另外你的服务器配好了没有?

liu_cj

SQLCA.Database = "tock@pbdata"
如果我不配 SQLCA.Database = "tock@pbdata"
那系统会让我选一个我需要的库,我选了之后点确定就出现了 error -255
"-255 Not in transaction. "