Re: classic ora-00904 & Crystal

Malcolm Dew-Jones wrote:
> DA Morgan (damorgan_at_psoug.org) wrote:
> : Paul wrote:
> : >
> : > "MarkD" <mad_at_itstrack.com> wrote:
> : >
> : >
> : >
> : >>Im new to oracle but I do have a background in sql server.
> : >>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.
> : >
> : > Can you access the data using Excel?
> : >
> : > Have you tried putting your fieldnames in quotes? Are you using any
> : > reserved words in your schema?
> : >
> : > Paul...
> : >
> : >>Mark D
>
> : What does Excel have to do with anything?
>
> Excel is a useful tool for debugging Oracle / ODBC access problems.

Except the OP was asking about Crystal Reports and the simplest and most effective solution is to stop using the Microsoft-centric ODBC driver and use the built-in native connection as recommended by both Oracle and Business Objects.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)