Problem selecting tables to display in crystal reports

[roncansan]

Hi,
I'm using crystal reports 9 to connect to Progress using odbc specifically the driver from OpenLink 3.20

Well, I'm able to see the all the tables from progress in crystal reports, even select columns I want to use, but when I try to see the preview I received the following error

Failed to open a rowset
Details:HY000:[OpenLink][ODBC][Progress Server] ** Unable to understand after -- "DECLARE". (247)

I know that this error indicates problems with the sql syntax; so I take a look at the sql statement produced by crystal

SELECT mb . credit-score-dt
FROM pro4 . mb mb

To my surprise there is a space " " before and after every point "."
"mb . credit-score-dt"

If instead of selecting tables in Crystal, I enter a sql command like this

SELECT mb.credit-score-dt
FROM pro4.mb mb

without the spaces it runs without errors.

Now the question

Have any one have the same problem?
If so, is there a way to fix the sql statement from crystal?
Also who is responsible of generating the sql statement crystal or openlink?

Thanks in advance

 

[OpenLink]

SELECT mb . credit-score-dt <br />
FROM pro4 . mb mb<br />
<br />
To my surprise there is a space &quot; &quot; before and after every point &quot;.&quot;<br />
&quot;mb . credit-score-dt&quot;<br />
<br />Thanks in advance

Hi,

This should be easy: in the words of http://wikis.openlinksw.com/dataspace/owiki/wiki/UdaWikiWeb/InstallProgress89LiteWin32 :

Use Space for SQL_QUOTE_CHAR- This is a Progress SQL-89 specific option. When set, the driver returns " " rather than "" to represent the fact that the database does not have a quoted identifier character. The ODBC specification states that " " should be returned, but some applications (like Crystal Reports) interpret this response to mean that the quoted indentifier character is a "space.".

So toggling that option in your DSN configuration should suffice.

HTH,

~Tim