Database Connector Error

[crumpm]

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

 

[kray4660]

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).

 

[crumpm]

All my other reports, connected to this database, are working normally, so I don't think it's a dbase problem. Thanks

 

[kray4660]

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.