Where I work we are in the process of changing our corporate database from an Informix On RedHat to a SQL Server on Server 2003.
Over the last 18 months I have created around 100 Crystal Reports in both CR 9 and CR 2008.
I have just tested some of these reports to see if they will just work if I change the ODBC connection.
When I do this I get the following error:
Failed to Retrieve Data from the Database.
Details: 42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'authority.auth.aualdocs'. [Database Vendor Code: 208 ]
My Question is... does anyone know how I can get these reports to work without recreating them.
I am REALLY hoping that there is a way to simply change the Datasource otherwise I will have to go and recreate nearly 200 crystal Reports... :S
The Company that has done the database conversion has said that I will most likely have to recreate them... but I REALLY don't want to.
Regards
Anita
IP Logged
