Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Ed Schaefer — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.