An ODBC connection to SAGE 100 can be made and tables are visible, however whenever trying to run a basic SELECT on a table the following error is given:
“[ProvideX][ODBC Driver]Unexpected extra token: .”
Using the same ODBC connection to an Access database for example has no issues when running a similar query.