Getting ODBC error 900 with a PREPARE statement

0 Likes

Problem:

Using different ODBC drivers resulting in an ODBC error 900 "Invalid SQL string":

EXEC SQL AT DBO

        PREPARE DYNSQL FROM :DB-SQL

END-EXEC.

Resolution:

OpenESQL soes not support using the AT clause with SQL PREPARE statements, so remove the 'AT DBO' from the statement.

Old KB# 7004
Comment List
Related
Recommended