Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

'Failed to retrieve data from the database'

Status
Not open for further replies.

Tstegen

Programmer
Nov 10, 2008
10
NO
I have a Crystal-report built on a table returned from a stored procedure.
When running this report on database A it runs OK.
When running the same report on database B I get the message 'Failed to retrieve data from the database'. No vendor code or other message is returned.
I'm running the report as administrator on both database and same software and procedures are installed.
Using CrystalXIrdc.

Any tips on what to check is appriciated!

Torbjørg
 
Its because report is still looking for DatabaseA. Go to
Database->Show SQL and you will see that.

To remove database name and make report portable go to
Database-> Set data source location

open up SP details by clicking (+) and then double click Overridden Qualified table name and then type in SP name as shown in Table name above.

Report will now work on DatabaseB

Ian
 
Thank you for quick answer.

I forgot to mention that we use a work-around for all our Crystal reports to make them database independent.

I have now tested the report on database C and it runs OK there.

Torbjørg
 
Guess your test on DB C makes it clear that the problem lies with DB B, not the report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top