informix csdk 3.5 for linux連sco unix下informix7.31問(wèn)題

baiyso

用informix csdk 3.5 for linux開(kāi)發(fā)的esqlc程序，訪問(wèn)sco unix下的informix7.31數(shù)據(jù)庫(kù)，

記錄都已經(jīng)查詢出來(lái)了，最后卻報(bào)錯(cuò)了：SQLCODE=-400，應(yīng)該是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連過(guò)低版本的informix

baiyso

找到原因了，連informix 7.31時(shí)不能用CONNECT TO :dbname USER :username USING :password語(yǔ)句。

還是老老實(shí)實(shí)用database dbname就行了，只是得在服務(wù)器端添加客戶端用戶。