Print Page | Close Window

Crystal 8.5 Crashing on ODBC Connection

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5389
Printed Date: 06 May 2024 at 5:08pm


Topic: Crystal 8.5 Crashing on ODBC Connection
Posted By: Goz_NZ
Subject: Crystal 8.5 Crashing on ODBC Connection
Date Posted: 01 Feb 2009 at 6:54pm
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 Smile

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


Print Page | Close Window