Re: ERROR -258, please help....

In <DEFo64.21y@nntpa.cb.att.com> mfm@addams.nse.att.com (Mike Michalowicz) writes: > >Can someone PLEASE help? This problem keeps arising and I cannot get away >from it?!?! With Informix ESQL 4.1, I keep getting error -258, >"System error - Invalid statement id received by the sqlexec process." >during a $PREPARE statement. > >I cannot give the code because they are simple statements and the error occurs >during complex situations that take forever to figure out. > >Here's one of many examples: >$OPEN CURSOR lalala >$CLOSE DATABASE >$DATABASE /tmp/my_database >$PREPARE my_prepare FROM "SELECT * FROM my_table" > >This example shows a cursor that was NOT closed before a database was closed. >This scenario causes Informix to return the error -258 on the final PREPARE >statement. (It took days to figure this scenario out) I am getting this >same error in different situations and it seems like this is Informix's >fault??? > >Any words of wisdom? >Mike Michalowicz Mike: If you already received my mail, I'm sorry; my provider has been wierd. I have had limited experience with ESQL/C, but this looks similiar to a problem I've seen using Informix 4GL when opening and closing multiple databases. Try preparing the close database statement and executing that. I know it's grabbing at straws, but it might work. ed schaefer