Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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.

↑ Back to the top

Cause

There is a comma in a Reference Code.

↑ Back to the top

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.

↑ Back to the top

References

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 966722
Revision : 4
Created on : 9/2/2020
Published on : 9/2/2020
Exists online : False
Views : 79