Informix Error -32412: USING clause unsupported. DB-Access will prompt you for a password.

Cause and resolution

USING clause unsupported. DB-Access will prompt you for a password.

DB-Access does not support the USING password clause in a CONNECT ... USER statement when it violates security. For example, do not type a password on the screen where it can be seen or include it in a command file that someone other than the user can read. To maintain security, DB-Access prompts you to enter the password on the screen and uses echo suppression to hide it from view.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-32412 fires when a CONNECT ... USER statement includes a USING password clause in DB-Access — per the official guidance, DB-Access doesn't support it for security reasons.

A CONNECT ... USER statement including a USING password clause, per the official guidance — the direct, only cause; a visible password on-screen or in a readable command file is a security risk DB-Access avoids.

Solutions / Resolution

Omit the USING clause and let DB-Access prompt for the password, per the official guidance — it uses echo suppression to hide the input from view.

Examples

A CONNECT with a visible password

CONNECT TO 'mydb' USER 'joe' USING 'secret';
-- -32412: DB-Access won't accept the USING clause

Corrected

CONNECT TO 'mydb' USER 'joe';
-- DB-Access prompts for the password with echo suppressed

Diagnostic Checks

Check the CONNECT ... USER statement for a USING clause, and remove it, letting DB-Access prompt for the password instead.

Related Errors / Related Topics

-32410 — "Syntax not supported by DB-Access." The general DB-Access CONNECT-syntax restriction this is a specific case of, for AS/WITH CURRENT TRANSACTION/USER clauses.

DB-Access doesn't accept a USING password clause in CONNECT ... USER, for security — omit it and let DB-Access prompt for the password.