Last month's FRx reports ran fine. This month, some of the reports are not.
We are getting this error in place of each page of report (if 50 page report then 50 of these errors):
- FRx Reporting Engine
- Source: FSSolIV451
Error 40002: 01000: [Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated.
Then this error with no report: This report yielded no data
-----------------------------------------------------------------------------------------------------------------------------------
I found this and tried this but this only took away the error and the report does not run:
To resolve the issue I manually modified the ODBC configuration at the workstation for the system and application databases as follows:
- Deselected “Use ANSI quoted identifers”
- Deselect “Use ANSI nulls, paddings and warnings”
- Deselected “Perform translation for character data”
-------------------------------------------------------------------------------------------------------------------------------
Solutions welcomed!
Thank you for looking at my question.
