Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Angry Unanswered: Issuing database queries

    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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?
    rws

  3. #3
    Join Date
    Sep 2003
    Posts
    2

    Talking

    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.
    Originally posted by Roelwe
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •