Kbase P145171: Crystal Reports errors when trying to query more than 2 tables when using an OpenLink ODBC Driver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/04/2009 |
|
Status: Unverified
SYMPTOM(s):
Error 247 when reading a multiple (3+) table JOIN in Crystal Reports 9 via SQL-89
Crystal Reports 2008 errors when trying to query more than 2 tables.
Failed to retrieve data from database details HY000
Database vendor code: 247
** Unable to understand after -- "DECLARE". (247)
FACT(s) (Environment):
Querying 2 tables or less works properly
Modified Windows Registry key and the issue still occurs:
[HKEY_CURRENT_USER\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\JoinBuilder]
"StarEqualJoinBuilder"="IVSLK13, IVPRO16, IVPRO17"
Windows
Progress 9.1D
Progress 9.1E
CAUSE:
Using 3rd party OpenLink ODBC driver.
FIX:
Install 9.1E with 4.10 Data Direct SQL92 driver and configure a DSN to use this driver.