ERROR [42000] [AcuCorp, Inc.][AcuODBC Driver]Expected lexical element not found

0 Likes

Problem:

Calling AcuODBC version 7.2 from a .NET application encountered error on select statement:

System.Data.Odbc.OdbcException: ERROR [42000] [AcuCorp, Inc.][AcuODBC Driver]Expected lexical element not found: <identifier> expected, ORDER found, near line 1, column 13

Resolution:

The error indicates that the syntax error begins at the location of the '^' symbol. In this case, the table name "ORDER" is a reserved word in most database systems, thus it is not allowed as a user defined table name.  Renaming the table to a non-reserved word should avoid this error.

Old KB# 2816
Comment List
Anonymous
Related Discussions
Recommended