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

baiyso

用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

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

baiyso

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

还是老老实实用database dbname就行了，只是得在服务器端添加客户端用户。