Page 1 of 1
Data source on runtime computer
Posted: Mon Mar 01, 2004 12:04 pm
by 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?
=> RE: Data source on runtime computer
Posted: Mon Mar 01, 2004 6:24 pm
by 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
=> RE: Data source on runtime computer
Posted: Sun Mar 07, 2004 12:44 pm
by 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
=> RE: Data source on runtime computer
Posted: Sun Mar 07, 2004 12:47 pm
by 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
==> RE: Data source on runtime computer
Posted: Tue Mar 09, 2004 6:03 pm
by 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