OLE DB report -- missing table owner

[former_member329101]

Dear support,

It was very strange that for a report that a report created using OLE DB ( MS for Oracle ).  When "Show SQL Query" all tables are properly prefixed with owner ( e.g. "OWNER"."TABLE_NAME" ).  When previewing data using Oracle user other than owner, the preview works fine.  However, when running the report in Crystal Viewer, all prefixes were gone. Since the user in Crystal Viewer is not the owner, ORA-00942 appears.  Please see attached CR log that displays the SQL within ( without table prefix "TFM". )

However, some report works, but not this particular report.  Is there any settings that can make it always prefixed with table owner?

Thanks!

-- Alex

[former_member183750 · Accepted solution]

Do not use OLE DB MS for Oracle. bad, bad, bad. They are old and never really worked that well. Use Oracle's divers.

Yo may also want to use the search box in the top right corner and search for 'oracle crystal'. Lots of info will come up for you.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[former_member11696]

MS Oracle Driver only supports Oracle up to Version 7. As Ludek indicated, use Oracle OLE DB Provider.

[former_member329101]

attached log file for reference

CengeaForest_18540_runtime.txt.zip