Skip to Content
0
Former Member
Sep 11, 2008 at 03:05 PM

Oracle DB Drivers for Crystal Reports with .Net 2008

16 Views

Hi,

I am using Embedded Crystal Reports with .Net 2008 (Crystal Reports Basic).

I have created a stored procedure in Oracle which is returing a REF Cursor as a result dataset. When i am trying to pull this Stored Proc from Oracle to Crystal Reports, it is throwing the below error.

-


Crystal Reports ActiveX Designer

-


Query Engine Error: '42000:[Microsoft][ODBC driver for Oracle]Syntax error or access violation'

-


OK

-


Please help me in resolving this error.

Note: I am using Microsoft ODBC Driver for Oracle and created a DSN to connect to Crytal Reports.

Thanks

Athmaram