Re: Crystal Reports works fine with Access, SQL Server, but not Oracle

In article <6djnlq$8op_at_bolivia.earthlink.net>, Randy Baker <rsbakerZ_at_msn.com> writes
>We have an application which can interface with Access, SQL Server, or
>Oracle. In all cases we use ODBC for the database connection. The same .RPT
>files work great with both Access and SQL Server, but we are making little
>progress with Oracle. It usually just says "SQL Server error".
>
>Any suggestions on what could be wrong or how we diagnose the problem? We
>are supplying a valid user name and password, and the application itself has
>no trouble accessing the database.
>
>Thanks
>
>--
>Randy Baker (remove Z from address in email replies)
>
>

We've found Crystal Reports works fine with Oracle. Is your ODBC set up correctly? (Use the Oracle ODBC Test application to verify, and make sure CR is using the same ODBC DSN).
Hope this helps.

-- 
Paul Brewer