baiyso 发表于 2010-12-25 00:51

informix csdk 3.5 for linux连sco unix下informix7.31问题

本帖最后由 baiyso 于 2010-12-25 00:52 编辑

用informix csdk 3.5 for linux开发的esqlc程序,访问sco unix下的informix7.31数据库,

记录都已经查询出来了,最后却报错了:SQLCODE=-400,应该是sqlcode=100啊!求助!

-400    Fetch attempted on unopen cursor.

This FETCH statement names a cursor that has never been opened or has
been closed. Review the program logic, and check that it will open the
cursor before this point and not accidentally close it. Unless a cursor
is declared WITH HOLD, it is automatically closed by a COMMIT WORK or
ROLLBACK WORK statement.

liaosnet 发表于 2010-12-25 11:58

建议还是别用太高版本的csdk连过低版本的informix

baiyso 发表于 2010-12-27 11:31

找到原因了,连informix 7.31时不能用CONNECT TO :dbname USER :username USING :password语句。

还是老老实实用database dbname就行了,只是得在服务器端添加客户端用户。
页: [1]
查看完整版本: informix csdk 3.5 for linux连sco unix下informix7.31问题