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!

Database Connector Error

Status
Not open for further replies.

crumpm

Technical User
Mar 29, 2010
31
GB
Hi all

I have a report in Crystal 12, that connects to an SQL database; some tables and a stored procedure.

The report was working fine until a couple of days agao, when I tried to refresh it, but it came up with
"failed to retrieve data from the databae"
"Unknown Database Connector Error"


I'm stumped by this as it rereshed perfectly when I first opened it, but every time after that , it fails.
This also happened to a colleague I asked to test the report.

Any ideas?
Thanks
 
Sounds like an issue on the database side. Do you have a way to verify that the database is up and running and that someone did not move it (it has happened to me).
 
All my other reports, connected to this database, are working normally, so I don't think it's a dbase problem. Thanks
 
When you open the report. Click on Database, Set Datasource Location. Click on the plus sign next to Properties and verify that there is nothing odd with the connection. Be sure to check the connection on any sub-reports also.

I do not have any other suggestions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top