Article

Failed to retrieve data from the database error running Crystal Reports

« Go Back

Information

 
Article Number000042243
EnvironmentProduct: OpenEdge
Version: 10.2B
OS: Windows
Other: Crystal Reports for .NET Framework 4
Question/Problem Description
Getting Left Outer Join error on the Crystal Report viewer invoked from Progress Application
Steps to Reproduce
Clarifying Information
- Error 210056 is returned  after upgrading the Crystal Report version from 11 to Crystal Reports for .NET Framework 4.0
- Errors 10713 and -210056 returned in the ODBC trace log 
Error MessageFailed to retrieve data from the database. Details: [Database Vendor Code: -210056 ]
Syntax error at or about (statement excerpt). (10713)
Defect/Enhancement Number
Cause
The Microsoft ODBC standard for SQL join syntax is the OJSyntax.  For Crystal Reports to interpret the expected join syntax for database drivers  that do not use the Microsoft ODBC standard, the driver name must be referenced in a registry key. 
 
 
Resolution
Update the registry key with the ODBC Progress database driver information and its required SQL join syntax as follows:
 
[HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\QueryBuilder\OuterJoinEscSeq] 
"NoOuterJoinEscSeq"="Progress OpenEdge 10.2B Driver,PGOE1025.dll" 
 
[HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Database\QueryBuilder\OuterJoinEscSeq] 
"NoOuterJoinEscSeq"="Progress OpenEdge 10.2B Driver,PGOE1025.dll" 
 
[HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Database\QueryBuilder\OuterJoinEscSeq] 
"NoOuterJoinEscSeq"="Progress OpenEdge 10.2B Driver,PGOE1025.dll" 
 
[HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0\Crystal Reports\Database\QueryBuilder\OuterJoinEscSeq] 
"NoOuterJoinEscSeq"="Progress OpenEdge 10.2B Driver,PGOE1025.dll"
Workaround
Notes
Attachment 
Last Modified Date5/2/2018 3:38 PM


Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025