Oninit
Talk to an expert →

Informix Error -407

-407 Error number zero received from the sqlexec process.

This internal error indicates a problem in the communication between the database server and the library functions that call it. Make sure that your program software is compatible with the database engine in use. If the error recurs, note all circumstances and contact IBM Informix Technical Support.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-407 is another internal communications-protocol error in the same family as -403: the client library received an error number of zero from the sqlexec process, which shouldn't happen under normal operation and typically points to a client/server software-version mismatch.

  1. A client library compiled/linked against a different server version than the one actually being connected to — the same general root cause as -368 and -403.
  2. A driver or client library bug in how error responses are decoded from the wire protocol.
  3. A rare server-side internal condition producing an unexpected zero error code in its response.
Solutions / Resolution
  1. Verify the client program's software is compatible with the connected database engine version, per the official guidance — this is the primary, most actionable check.
  2. If the problem persists after confirming version compatibility, document all relevant circumstances (client version, server version, statement being executed) and contact IBM Informix Technical Support, per the official guidance.
  3. Check for a client driver/library update if the error recurs consistently with a specific client.
Examples
Confirming client/server compatibility
-- Compare the client library's compiled/linked version against
-- the actual connected server version before assuming a deeper
-- bug is involved.
Documenting circumstances for escalation
- Client driver and version in use
- Server version
- Exact statement being executed
- Frequency: one-off or reproducible?
Diagnostic Checks
  1. Confirm the client library's version is compatible with the connected server's version.
  2. Check for available client driver/library updates.
  3. Confirm whether the error is a one-off or reproducible.
Related Errors / Related Topics
  • -403 — "The size of a received row disagrees with the expected size." Another internal client/server-communication-level error in the same general protocol family.
  • -368 — "Incompatible sqlexec module." A related, more explicitly named client/server version-mismatch error.

Check client/server software compatibility first — it's the primary actionable step before escalating this internal-level error to IBM Informix Technical Support.