Failed to retrieve data from the database

[Former Member]

Looking for assistance regarding the following issue. Hopefully, there is an explanation or fix out there.

Receiving the following error for Crystal XI created reports that use package procedures:

Failed to retrieve data from the database. Details: [Database Vendor Code: 6550 ] Failed to retrieve data from the database. Details: [Database Vendor Code: 6550 ] Failed to retrieve data from the database. Error in File C:\Windows\TEMP\Report1017 {98602EA0-1FE8-43B5-A3B3-B812351B3DD2}.rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: 6550 ]

**Note - the package procedures are located in a different schema than the .net application I'm trying to run the report on. The .net application is on a webserver that has the crystal XI runtime installed. The report was created with XI sp6. Placing the package procedure on the same schema as the report produces the same error as above. Taking the procedure out of the package and running the report produces results.

Is there an issue with package procs in this version of crystal or is there some other explanation.

[former_member11696]

Pakages work fine in CR.

First thing to do is verify the report works in CR DEsigner when you change the schema. Save a copy of the verified report and the run that in your app. If that works then check your Set Location code.

Seems to me it's a permission issue on the Server of from the WEB Server account running the report.

Add debugging try/catch to your app to find out what line of code is failing.

For more help on coding go to the .NET SDK forum.

Don