Oninit
Talk to an expert →

Informix Error -32410: Syntax not supported by DB-Access.

Cause and resolution

Syntax not supported by DB-Access.

DB-Access does not support the AS, WITH CURRENT TRANSACTION, or USER clause of the CONNECT statement, although the database server supports it. Use proper SQL statement syntax when you run your CONNECT statement in DB-Access.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-32410 fires when a CONNECT statement uses syntax the database server supports but DB-Access doesn't — per the official guidance, specifically the AS, WITH CURRENT TRANSACTION, or USER clauses.

  1. A CONNECT statement using the AS, WITH CURRENT TRANSACTION, or USER clause in DB-Access, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Use proper SQL statement syntax that DB-Access supports when running CONNECT, per the official guidance.
Examples
An unsupported CONNECT clause in DB-Access
CONNECT TO 'mydb' AS 'conn1';
-- -32410: the AS clause isn't supported by DB-Access
Corrected
CONNECT TO 'mydb';
Diagnostic Checks
  1. Check the CONNECT statement for AS/WITH CURRENT TRANSACTION/USER clauses, and remove them when running in DB-Access.
Related Errors / Related Topics
  • -32412 — "USING clause unsupported. DB-Access will prompt you for a password." A related DB-Access CONNECT-syntax restriction, on the USING password clause specifically.

DB-Access doesn't support the AS/WITH CURRENT TRANSACTION/USER clauses of CONNECT, even though the server does — remove them.