Unable to change data source in Crystal reports 9

I have a report set up on our test environment which uses a datasource called DEFAULT, which is also the name of the datasource on the client's prod开发者_JS百科uction server. (Both are ODBC)

The databases in our test environment are called systemname_clientname but on site they are simply systemname.

I modified a report for the client and put it onsite then changed the datasource to the client version (DEFAULT.systemname) but the report keeps throwing errors saying that the object systemname_clientname.dbo.table does not exist.

I can't seem to make it realise that it is no longer pointing at the systemname_clientname database.

This is using Crystal Reports 9 and the reports are launched using an ASP page written in VBScript.

Google has been most unhelpful and my co-workers are equally stumped, can anybody offer some help here?

Database->Set Datasource Location has a bug in Crystal XI at least, maybe other versions. Select the database and then updating doesn't update the source of every table.

If you expand the properties of each table you will see that it's still pointing at the old data source.

Try updating the data source for each table one by one.

Yes, it is tedious, sorry.