Re: classic ora-00904 & Crystal

Malcolm Dew-Jones wrote:
DA Morgan (damorgan@xxxxxxxxx) wrote:
: Paul wrote:
: > : > "MarkD" <mad@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.

Relevant Pages

  • Re: Whats so bad about ODBC
    ... It is far better to connect to Oracle using the native connectivity. ... What exactly might be a problem with ODBC? ... data to be fetched to the client, and have it filtered on the client. ... actual execution paths are often unpredictable, ...
    (comp.databases.oracle.server)
  • RE: Windows to Oracle
    ... resolved yet (with respect to a Windows OS). ... and Oracle DBDs. ... Need to install Oracle on your own machine before you can connect to the ... If you are truly trying to use ODBC, why are you specifying the Oracle ...
    (perl.dbi.users)
  • Re: MS OLE DB for ODBC with Oracle ODBC source headaches
    ... John Bell wrote: ... the Oracle OLEDB provider (as opposed to the Microsoft OLE for ODBC ... >> I have no idea why sometimes I can connect to the linked server with no ...
    (comp.databases.ms-sqlserver)
  • Re: Probleme unter Access beim Zugriff auf Oracle-Daten
    ... Der Zugriff erfolgt via ODBC mit dem Microsoft Treiber. ... Hier wird allerdings nicht wirklich etwas Bewegendes gemacht: mit Access-backend verkünpfte Tabellen, mit via ODBC eingebundene Oracle Tabellen und eine PT-Abfrage. ... Schema: Es gibt zwei Schemata, welche vom Aufbau absolut identisch sind. ...
    (microsoft.public.de.access.clientserver)
  • Re: MSACCESS hangs
    ... Client -- Windows XP, MS Access 2003 using Oracle's ODBC driver ... I would try to isolate whether it is the query or ODBC. ... Senior Oracle Dba ... other thoughts are windows patches may have been installed, ...
    (comp.databases.oracle.server)