Statement(s) Could Not Be Prepared. (SQL Error 37000)


Symptoms


"37000: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared" This error occurs when generating a report.

Cause


There is a comma in a Reference Code.

Resolution


SQL Server interprets the comma as a separator. Remove the comma from the Reference Code within your GL Package and then modify your report formats to avoid this error.

References