Hi to all,
I installed an informix db on RedHat Linux.
I create a client application to accessing to db, I can open a connection but I can't issuing a query to this db, it responds with this message :X07003:-404:Cursor specification cannot be executed.
I used a ITCursor.Prepare() method and , in another trial, ITQuery.ExecForIteration() method but the negative message is the same!!
How can I issuing the db?
Thanks to all.
Have a nice day.
Shrek.

Hello this is the explanation of the 404 error:

informix - /usr/informix>finderr 404
-404 The cursor or statement is not available.

You probably used a statement that names a cursor that was released with the
FREE statement. Review the program logic and check that the cursor specified
is declared and opened, but not freed, prior to reaching this statement.

If the error occurred on a command that specifies a variable rather than a
cursor, the statement was not prepared before you tried to execute it.

This error can also occur if the cursor or statement is not available
because the connection to the server does not exist or was lost.


-404 A NULL control block has been passed as an argument.

Review the way the program constructs the sqlda and related data
structures; somehow it is setting up a null pointer. If the program is
in IBM Informix 4GL or another language in which the sqlda is not
constructed directly by the program, or if this statement only refers
to host variables by name, this error should not occur. Contact Technical Suppor
t at tsmail@us.ibm.com.

Only Version 4.1 and earlier database servers return this error code
with the meaning shown.


Maybe it helps a bit to know what client development tool you use... and what type of connection - ODBC, JDBC, OLEDB, NATIVE?

Thanks,
I resolved the problem.
The connection wasn't ok because installation of db wasn't complete: sqlhosts file and some environment variables wasn't setting......

Thank you.
Shrek.