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
One tip - look at the SQL statement that Crystal is using - can you copy that statement and execute from the SQLConnect test connection ? I have found that in some of my reports - Crystal behaves a little diff when you use the direct connection vs the ODBC connection. Could not get some of my reports to format the SQL statement correctly for my ODBC connection - had to switch to the "direct" Oracle driver.
Jim..
Paul Brewer wrote in message ...
>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
Received on Sun Mar 15 1998 - 00:00:00 CST