Re: classic ora-00904 & Crystal

MarkD <mad@xxxxxxxxxxxx> wrote:
> I created a view and attached it as a datasource in Crystal. I can add the
> fields to the report, but when I preview the report, I get "ODBC Error
> ..... ORA-00904: invalid identifier". I've been looking for a solution
> for a few days and no one seems to know.

I would start an Oracle Client Trace by setting
TRACE_LEVEL_CLIENT=SUPPORT
in $ORACLE_HOME/network/admin/sqlnet.ora (on the machine where the
client is).

In the trace file you will see the statements generated and hopefully
can identify the one that causes the error.

Yours,
Laurenz Albe
.

Relevant Pages

  • Re: Access 2000 reports: sql view does not exist
    ... yeah it sounds like an 'ownership problem' ... > report which uses viewTest as its datasource, there is an ODBC error ... > based a report on it and it too fails with the same error. ...
    (microsoft.public.access.adp.sqlserver)
  • Exporting Report to Snapshot - ODBC Error
    ... When I am exporting a report from Access 2003 to Snapshot Viewer, ... getting an ODBC Error when it is almost finished, and if I click on ok, the ...
    (microsoft.public.access.reports)