Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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

Need more help?

Expand your skills

EXPLORE TRAINING >

Get new features first

JOIN MICROSOFT 365 INSIDERS >

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×