Chinaunix

标题: informix csdk 3.5 for linux连sco unix下informix7.31问题 [打印本页]

作者: 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就行了，只是得在服务器端添加客户端用户。

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)