Change of SQL database

[neilmcdonald]

Hi,

I have a crystal report written in V9, linking to a SQL database. The report was written using database A, but needs to be run on database B. The database structures are identical, but the names are different. I have set a new datasource location, but get the following error message:

Query Engine Error: '42S02:[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'Database_A.Tablename'.'

Obviously, Database A doesn't exist, but how can I point it to Database B?

 

[Turkbear]

Hi,
In CR Designer, use the Verify Database option ( under the Database options) to update the report..

 

[vidru]

Database > Set Datasource Location > browse to the correct location at the bottom and highlight it > highlight the corresponding table in the upper half of the window > click the 'Update' button.

-dave

 

[neilmcdonald]

Thanks for the response. I've tried both of the above, but I'm still getting the same error message.

I'd be grateful for any more ideas!

 

[Katy44]

I have just had the same thing with a report being run on a test database going live and vidru's method worked fine. It's strange that it hasn't worked for you. Do you have subreports in your report?

 

[neilmcdonald]

Yes - there are three subreports. Do I need to do something to the individual subreports?

 

[Katy44]

In your top box, you will have all the connections - for the main report and each subreport. You will need to change them all (but you will be able to do this from the main report, you shouldn't have to open the subreports in design view or anything). It sounds like you may have already done this though?

 

[neilmcdonald]

Hi,

I've managed to get this working, although a bit more long winded than normal. Usually, when setting the database location, I can select the two databases and choose update. This time, I had to do each table individually.

Thanks to everyone for your advice - it's much appreciated.