"ODBC Error:[Informix][Informix ODBC Driver]

[balajee]

Hi
I am trying to create a report in Report Designer of Info Desktop. I am joining two tables off Informix Database. When I try to Preview I get the error:
"ODBC Error:[Informix][Informix ODBC Driver]General error:Syntax error."

When I check the SQL generated by the designer, I see the statement:{oj table1 INNER JOIN table2 ON
table1.field1=table2.field1}

If remove the "oj table1 INNER JOIN table2 ON" and the braces{} then it works. Is there any other way to avoid editing the SQL?

Thanks

 

[balves]

What driver are you using? Crystal supplies a driver, usually labeled OBBC-CRINF. Or are you using your own Informix driver. Whichever you're using, try the other one.