Application Delivery Management
Application Modernization & Connectivity
CyberRes
IT Operations Management
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
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.