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:
>From: "Randy Baker" <rsbakerZ_at_msn.com>
>Subject: Crystal Reports works fine with Access, SQL Server, but not Oracle
>Date: Wed, 4 Mar 1998 09:16:47 -0500
 

>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.

We saw something like this with a CR application trying to use the latest Microsoft ODBC driver for Oracle (in the ADO 1.5 pack.) Switching to the latest 32-bit driver from Oracle fixed the problem (it was something odd with joins, as I recall.)

Rick Brown
rick_at_onramp.net Received on Wed Mar 04 1998 - 00:00:00 CST