Data source on runtime computer

[Joe_Nuhfer_(Guest)]

I have created a report accessing and Access database on a computer running development R&R V10 and Win XP. I can run the viewer just fine. I copied the report definition (.RSW), viewer exe and dll^s to computer running W98SE. When I try to set up an icon to run viewer or run the viewer by opening the .RSW file, it does not find the database. I get the message "Library error (cannot open file) reading report ... .RSW. I have created an ODBC entry, entered the default data directory in the rsw.ini pointing the the directory containing the Access database all in vein.____If I run the viewer from the Programs directory and answer the prompts, it finds the database and executes the report correctly.____As this is my first time creating a report and moving it to a runtime computer, can you give me a list of items to check so that it will find the database?

[kfleming]

When you set up the Datasource in the ODBC manager, make sure that you explicitly select your Access database there.____Kathleen__R&R Support

[Joe_Nuhfer_(Guest)]

I have checked and tested the ODBC connection in the target computer successfully with Excel. It works just fine.____I have specified the ODBC name in the data source section of the.RSW file. In the rsw.ini file, I put a DefaultDataSource=<ODBC Name> in the default section of the rsw.ini file. Still have had no success.____Do you have any other suggestions?____Joe

[Joe_Nuhfer_(Guest)]

More ...____When I run the viewer, the data source panel defaults to __C:Program Files. I have not been able to get this to change.____Joe

[kfleming]

R&R saves the name of the data source to use inside of the report definition. So that data source name must be present on the target machine and must point to the named MDB file.__Otherwise you would need to set up a runtime control file and add an RI_DSOURCE to override the saved data source name.____Kathleen__R&R Support