Re: Oracle privileges and Crystal Reports

kris p wrote:

> Hello everybody,
>
> I'm having trouble running some Crystal 8.5 reports that
> were created in and work with Oracle 8. The reports are
> printed from an application through the Oracle 8.1.77 ODBC
> driver and work intermittently. In the Crystal Reports
> designer they always work.
>
> Someone has told me that the privileges of the database
> that the reports were created in could affect whether the
> reports print or not in that a report could reach for data
> outside the user's schema/space/whatever and get data from
> a table of the same name, and would fail if the structure
> does not match the report's, if the report/database user
> has privileges that allow table access outside the user's
> schema/space/whatever. Any truth in that? The report itself
> is fine and I get the 0x80047602 error from Crystal, 'field
> not found'.
>
> Thanks in advance for any help.
>
> kristoff plasun

Truth in all of it. Have your DBA verify you have the permissions required.

And dump ODBC and use Crystal's native Oracle connectivity.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)