Hi,
We have a client that runs our application from two different folders. Here is a sample how it is setup;
Folder1
MyApp.Exe
MyApp.Ini (pointing to a database in the folder DataFoder1)
Folder2
MyApp.Exe
MyApp.Ini (pointing to a database in the folder DataFoder2)
We have an ODBC connection to the database to run crystal reports (ver 8.5)
When MyApp runs and the user goes to reports section, we physically change the DSN file to point to the database based on our ini path setiing. We don't have any problem if you run application from one folder at a time. The problem comes when the app is running from both the folders. One would get wrong report as other user has already changed the database location.
Is there a way we can temporary change the location of the database in memory before running the report? Please help us and would appreciate if it is explaind with the code. Thanks,
We have a client that runs our application from two different folders. Here is a sample how it is setup;
Folder1
MyApp.Exe
MyApp.Ini (pointing to a database in the folder DataFoder1)
Folder2
MyApp.Exe
MyApp.Ini (pointing to a database in the folder DataFoder2)
We have an ODBC connection to the database to run crystal reports (ver 8.5)
When MyApp runs and the user goes to reports section, we physically change the DSN file to point to the database based on our ini path setiing. We don't have any problem if you run application from one folder at a time. The problem comes when the app is running from both the folders. One would get wrong report as other user has already changed the database location.
Is there a way we can temporary change the location of the database in memory before running the report? Please help us and would appreciate if it is explaind with the code. Thanks,