I've just aquired a new role of BI administrator. I want to connect Impromptu 7.1.724.0 to a MSSQL Great Plains 8.0 DB. I am getting the error below during my testing. Can anyone shed some light on this for me? I'm not doing any fancy joins, just a plain report out of one table.
********************************************************
Error number -239:
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-DBPARSER, The underlying database detected an error during processing of the SQL request.
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'EMPLOYID'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
*********************************************************
********************************************************
Error number -239:
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-DBPARSER, The underlying database detected an error during processing of the SQL request.
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'EMPLOYID'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.
*********************************************************