Failure to retrieve data from the database (Vendor Code 6550)

[#1]

I am having a trouble with two of the 6 reports that I have created. I am using Crystal XI and Oracle 10g. The underlying database object is a stored procedure that accepts as input a start time as a TIMESTAMP, an end time as a TIMESTAMP and a furnace number as a number. I have a cursor ref as a return parameter.

When I run the stored procedure in Oracle I get the selected records and can view them on the screen.

When I refresh data on the report in Crystal XI developer, the designer asks me for the start and end time and furnace number. When I input these values the report displays properly.

When I launch the report from my VB .NET 2005 application I am asked for the username and the password for the database (this is another problem I need to solve as this information I put into the program seems to be ignored in my program) then I receive the following failure message:

Failure to retrieve data from the database (Vendor Code 6550)

When I launch the other reports, they only ask me for the username and password then they display the proper data.

The main difference between my other reports and the two that are returning the above failure code is that the other reports are to either tables or views. The two that don't work are tied to stored procedures. I there any way that I can solve this problem or at least get more information?

Any help would be greatly appreciated. Let me know if you need any other information.

[Former Member]

I am now trying Don Williams suggestion on Aug 26, 2008 11:43 PM. I am exporting the main report once it is loaded from the .NET web application, and I will try to reopen it at the Crystal Report Developer to see what's going on.

When I go to the main report's subreport hyperlink and right click it will actually have an option to Edit Sub Report as per the following print screen.

I use this "edit sub report" to both explore the "SQL Explorer" for both the Designed Sub Report against the exported RPT sub report.

SQL Explorer View for Designed Sub Report

SQL Explorer View for Exported Sub Report

I don't understand why does the SQL Explorer lay out is different between the Designed Sub Report against the Exported Sub-Report Lay out. Is this caused by the way the .NET web application or is it caused by the way I assigned the datasource?

[former_member11696]

Those screen shots don't tell us anything.

Click on Database, Set Location and expand the connection info. This will tell you what the connection info is. Both Main and Subreports connections should have the same name, if not then the subreport code is not being logged on.

Don