Parsing Error and NO Idea what to look at
435898Apr 2 2007 — edited Apr 4 2007I installed OMWB, ran the exporter tool, and am trying to figure out the errors. The errors all appear to revolve around where there is an ODBC connection from the Access app to another Oracle database. The error that I am getting states:
Error occurred on line 1: oracle.mtg.msaccess.parser.queryparser.ParseException: Parse error at line 1, column 1. Encountered: CREATE
There is no CREATE statement is the sql. The sql is an INSERT/SELECT from the Access database into an Oracle table in an existing database/schema.
What does the parser need me to change? I have an ODBC connection established and working because the Access app currently uses it. Any suggestions are greatly appreciated!