1181187 - Error: "Failed to open a rowset. Details: 42000:[Minisoft][3kodbc.dll]Syntax error in table list"

• Reports migrated to Crystal Reports XI.
• Reports have more than two linked tables.
• Opening report returns the following error message "Failed to open a rowset. Details: 42000:[Minisoft][3kodbc.dll]Syntax error in table list."

Crystal Reports 9 and later versions are using Microsoft ODBC standard for SQL join syntax, which is OJSyntax. If Crystal Reports uses a driver that does not support OJSyntax, then the driver should be referenced in the registry key for Crystal Reports along with the relevant SQL join syntax.

WARNING: The following resolution involves editing the registry. Using the Registry Editor incorrectly can cause serious problems that may require you to reinstall the Microsoft Windows operating system.

Use the Registry Editor at your own risk. It is strongly recommended that you make a backup copy of the registry files before you edit the registry. For information on how to edit the registry key, view the 'Changing Keys And Values' online Help topic in the Registry Editor (Regedit.exe).

Refer to Note 1323322 for more information.

For MiniSoft HP3000 type databases and the 3kodbc.dll driver, the following registry keys need to be entered:

Crystal Reports 9

1. Browse to the following registry sub key: HKEY_CURRENT_USER\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\JoinBuilder.
2. Edit the following Value (or create it if it does not exist): OJSyntax.
3. Give it the following value: "OracleJoinBuilder"="3kodbc".

Crystal Reports 10

1. Browse to the following registry sub key: HKEY_CURRENT_USER\Software\Crystal Decisions\10.0\Crystal Reports\Database\QueryBuilder\JoinBuilder.
2. Edit the following Value (or create it if it does not exist): OJSyntax.
3. Give it the following value: "OracleJoinBuilder"="3kodbc".

Crystal Reports XI

1. Browse to the following registry sub key: HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Database\QueryBuilder\JoinBuilder.
2. Edit the following Value (or create it if it does not exist): OJSyntax.
3. Give it the following value: "OracleJoinBuilder"="3kodbc".

Crystal Reports XI Release 2

1. Browse to the following registry sub key: HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal Reports\Database\QueryBuilder\JoinBuilder.
2. Edit the following Value (or create it if it does not exist): OJSyntax.
3. Give it the following value: "OracleJoinBuilder"="3kodbc".

Please refer to the following:

• Note 1212698
• Technical paper How to resolve join syntax errors in Crystal Reports 10

Minisoft, join syntax, 3kodbc.dll, Failed to open a rowset, Syntax error in table list, Details: 42000 , 1032491 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed