ODBC Driver and Crystal Reports 9 (OpenInsight 32-Bit)
At 14 JAN 2003 01:10:42PM Peter Ashby wrote:
In attempting to test the odbc driver with Crystal Reports Advanced version 9 we get the following:
Failed to Open Rowset
details: 42000:Revelation Software IncRevelation ODBC Driver SQLPrepare Syntax Error
We see the table and the dictionary items fine so that implies the driver is configured properly and oengine loads.
The sql request that is generated is as follows and appears to be valid:
SELECT "COMPANY"."ID", "COMPANY"."STARTUP_MENU", "COMPANY"."NAME",
"COMPANY"."PARENT_ID"
FROM "COMPANY" "COMPANY"
We can use the odbc driver from Access 2002 to the same table and get all rows returned (all 2 rows so this is not a lot of data we are testing with.
Any suggestions?
OI 4.1.2
W2k Pro sp2
At 14 JAN 2003 02:13PM Karl Pozmann wrote:
Make sure the dictionary entries on the OI side are
VARCHAR(255)
Or less than 255….
At 14 JAN 2003 02:33PM Peter Ashby wrote:
All are Varchar(25) or less. Only 7 dict items. Small test file. Any other things to look at? Thanks.
At 14 JAN 2003 03:28PM Karl Pozmann wrote:
From VB, we would use
SELECT ID, STARTUP_MENU, NAME, PARENT_ID FROM COMPANY
We have verified ID is not a reserved word.
Under Control Panel-Administrative Tools-ODBC Source there is an option to start a log, SQL.LOG which may be of use.
At 14 JAN 2003 05:10PM Peter Ashby wrote:
The answer is that you must enter the SQL command manually into Crystal and not let it build the statement -
This does not work (built by Crystal using wizard)
SELECT "COMPANY"."ID", "COMPANY"."NAME", "COMPANY"."PARENT_ID" FROM "COMPANY" "COMPANY"
This does word as a manual command
SELECT ID, NAME, PARENT_ID FROM COMPANY
Thanks for the assistance
At 14 JAN 2003 05:40PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Peter
SELECT COMPANY.ID, COMPANY.NAME, COMPANY.PARENT_ID FROM COMPANY
should also work. I must admit to being unfamiliar with the multiple quote syntax!
World Leaders in all things RevSoft
