Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Crystal Reports works fine with Access, SQL Server, but not Oracle
Try to download PDSODBC.ZIP from crystal's ftp site. This might solve your problem.
Rick Brown wrote in message ...
>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 Fri Mar 13 1998 - 00:00:00 CST