Skip to main content

Getting ODBC error 900 with a PREPARE statement

  • February 15, 2013
  • 0 replies
  • 0 views

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