<
http://www.progress.com/media/general/spaces/clear.gif>
From Progress Knowledgebase:
<
http://www.progress.com/media/general/spaces/clear.gif>
<
http://www.progress.com/media/general/spaces/clear.gif>
<
http://www.progress.com/media/general/spaces/clear.gif>
Kbase Id:
<
http://www.progress.com/media/general/spaces/clear.gif> 20071
Title:
<
http://www.progress.com/media/general/spaces/clear.gif> Error 247
Using Crystal Reports via ODBC Driver
Creation:
<
http://www.progress.com/media/general/spaces/clear.gif> 23-Aug-2000
Modified:
<
http://www.progress.com/media/general/spaces/clear.gif> 23-Aug-2000
<
http://www.progress.com/media/general/spaces/clear.gif>
SUMMARY
This solution provides a workaround to the following error message
that can occur as you as you generate a report using Crystal Reports
7.0 and connect to a Progress Database via a MERANT ODBC Version 3.50
or 3.60 driver. The error message:
Unable to understand after -- "<string>". (247)
EXPLANATION:
If you specify two links between tables in the database, the report
works without problem but when you specify a link to a third table,
the error appears. It makes no difference if you are linking different
tables or using different linking methods.
The message means that Progress cannot understand part of the
statement. No error occurs if you use for example, MS Query.
SOLUTION
The problem does not come from either Progress or the MERANT ODBC
driver but is from within Crystal Reports Version 7.
The Seagate website has a workaround for the problem.
Follow these steps:
1) Go to the following URL:
http://support.seagatesoftware.com/updates/default.asp
2) Under the "Enter Filename Here" Label, type in
"odbcregs.zip" and press the Enter key.
This brings you to a page where you can download
the "odbcregs.zip" file.
3) Execute the "OUTJOIN.REG" file which is one of the
six files in the zipped files.
NOTE: You do not need to replace the p2sodbc.dll
file with the one included in the zipped file
because you already have the newer version.
4) Get the file name for your ODBC driver.
Go into Control Panel and open the ODBC
Administrator.
5) Click the User/System tab.
6) Find your ODBC data source.
7) Look at the driver name that corresponds with that
data source then click on the Driver Tab.
8) Look up that driver name (the file name is to
the right of that line.
For example:
Driver Name Filename
CROR7 cror713.dll
9) You must edit the Registry to add the
file name. (Always back up the Registry before
modifying it).
Go to the the following key:
HKEY_CURRENT_USER > SOFTWARE > SEAGATE
SOFTWARE > CRYSTAL REPORTS > DATABASEOPTIONS >
OUTERJOIN
Click on the PlusEqual label, right click and
choose to "modify".
Add your file name (without the .DLL).
Default value not set
AccessDriver "odbcjt16,odbcjt32,qbodbc"
DataBaseName "qeinf506,qeinf507"
10) Open Crystal Reports.
The SQL syntax should have changed to be the
correct syntax for your database.
hbackstr 23/Aug/2000
-----Original Message-----
From:
slc@... [mailto:
slc@...]
Sent: Thursday, November 08, 2001 3:31 PM
To:
vantage@yahoogroups.com
Subject: [Vantage] Crystal Report Error
Has anyone gotten a Crystal Reports database error #247? It
says "ODBC error: [MERANT][ODBC PROGRESS driver][PROGRESS}**Unable to
understand after--"DECLARE".(247". What is wrong and how do I fix it?
Sonya Cover
Electron Energy
[Non-text portions of this message have been removed]