Kbase P31224: Unable to add tables to reports in Crystal Reports 9 via SQL-89 ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 8.3E
Progress 9.1D
MERANT 3.70 32-BIT Progress SQL-89
MERANT 4.0 32-BIT Progress SQL-89
SYMPTOM(s):
Trying to add table(s) to a report via standard ODBC connection results in an ODBC error
Query Engine Error: 'HYC00:[MERANT][ODBC PROGRESS driver]Optional feature not implemented"
Using SQL-89 ODBC driver to make the connection
Can create a COMMAND and view data, providing that no Progress date fields are present in the table
CAUSE:
Crystal Reports 9 Query-Engine uses quotation marks within its database queries.
The Merant SQL-89 ODBC drivers do not support the use of quotation marks within queries.
FIX:
Crystal Decisions has released a patch which will allow the quotation marks used in database queries to be switched off.
A connection between Crystal Reports 9 and Progress via SQL-89 is then possible.
The solution and HotFix are available at the following URL:
http://support.crystaldecisions.com/library/kbase/articles/c2013774.asp
Download and install the Hotfix
The HotFix will add a registry string value called "NoQuotes" at:
HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\NameBuilder
For the Merant 3.70 32-Bit Progress ODBC driver, NoQuotes should be set to "IVPRO16" (which is the name of the Merant ODBC DLL).
For the Merant 4.00 32-Bit Progress ODBC driver, NoQuotes should be set to "IVPRO17".
Configuring the Connection in Crystal Reports 9:
1) Select OLE DB (ADO) in "Create New Connection"
2) Select "Microsoft OLE DB Provider for ODBC Drivers", then Next
3) Select the ODBC connection to be used, then Next
4) Enter details of the ODBC connection, then Next then Finish
Please note that the first time that the report is previewed the following message will be displayed:
"The database table <table> cannot be found. Proceed to remove this table from the report?"
Answer No to this. The message should only appear on the first Preview.