Hi there,

First post so please bear with me:

I am trying to create an ODBC connection to an Oracle 10g database using Crystal Reports 8.5.

1. I create a new report
2. In Data Explorer screen I specify ODBC -> <ODBC Datasource Name>
3. Under Options I only return Stored Procedures
4. Select OK
5. Provide Login Details for Oracle
   

And Crystal crashes. No warning nothing just disappears with only the following in the error log:

Faulting application crw32.exe, version 8.5.0.217, faulting module ntdll.dll, version 5.1.2600.5512, fault address 0x000116d4.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

The interesting thing is that if I try to connect using anything but the stored procedures it works fine. If I count the number of Stored Procedures being returned it is 8000.

Regardless of how many i drop/add in the Oracle DB the number stays the same.

The number of stored procedures in the Oracle DB is only 292 according to Toad.

What I do know it is not is:

• Something fixed by doing updates
• An issue local to the server (I have tried ODBC connect from 3 different machines)
• User permissions error
• Actual ODBC Connection (tests successfully)

Has anyone ever come across a situation where Crystal 8.5 is falsly reporting the number of results returned by the DB (i.e 8000 SP's instead of 292)?

It seems to point to a buffer overrun issue or ODBC driver issue so please feel free to offer advice and point me in the right direction

And yes ... I have tried turning it off and on again .... several times