Crystal Reports 9 closes unexpectedly when running Store procedure

[wilsonmichael]

I trying to create a new report in crystal reports 9. when selecting a storedprocedure to add to the report i get prompted with its parameters. I fill them in and click ok and the application just closes on its own. It only happens with this new procedure. All others work fine.
any ideas.

Mike

 

[synapsevampire]

Since it probably depends on technical information, see if you can find out what type of database you're using, it's version, and what connectivity is used within the Crystal Report.

A common problem is using the wrong connectivity, such as an ODBC driver not supplied by Crystal when one is available, or not conforming to Crystal's SP requirements for Oracle.

Keep in mind that sharing technical information will help other's assist you, not sharing it is wasting everyone's time.

-k

 

[wilsonmichael]

The Database being used is Oracle 9
I am connecting through an ODBC datasource and the driver is the CR Oracle Wire Protocal ODBC Driver 4.10.00.04 from DataDirect. The driver is dated 4/10/2002 and comes with Crystal Enterprise 9.

The Crystal Reports 9 version is 9.2.3.738

 

[synapsevampire]

You may have a data type which is unsupported by the driver.

Try CASTing any newer data types to standard data types.

I don't have CR 9 installed here but as long as it's the CR supplied driver it might work (I wasn't aware that they use a Wire Protocol driver these days).

-k

 

[wilsonmichael]

all the data types are either varchar2, date or number. Nothing different between the other procedures.

 

[Reebo99]

Try using the native connection within Crystal rather than the ODBC driver.

When creating a new report choose
Create New Connection
Oracle

Then specify the Schema as it appears in your tnsnames.ora



Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.

 

[wilsonmichael]

In testing this procedure i decided to change the name of the it. When i ran it the procedure worked. In checking this further it turns out the name of the procedure was too long. The procedure had 30 characters and the longest one i had before was 28 characters. Thats where i came to the conclusion about the name.

Where oracle allows 30 characters and most of the other drivers do as well. The CR Oracle Wire Protocal ODBC Driver 4.10.00.04 from DataDirect only allows 29. When you try to execute a procedure with more then 29 characters Crystal Reports just shuts down without displaying an error message or an error log.

Thanks to all you responded regarding this issue

Mike