 |
|
||||||||||
|
M.A.R.S |
||||||||||
|
This forum is for the sole use of MARS users. ChristianSteven Software will not accept any responsibility for the contents.
|
||
| Return to Website | ||
 First |
 Prev |
 Reply |
 Forum |
Next  |
Last  |
| Viewing Page 1 of 1 (Total Posts: 3) |
| Author | Comment |
|
Pieter
Oct 26, 05 - 6:46 PM |
MARS cannot connect to the system DSN while MS Access can.
When i manually start a schedule, MARS cannot connect to the System DSN. - A system DSN is defined - it shows up in MARS - User-Id, password and DSN Name are filled, Database Name is empty - still , the following error occurs: PC Name: C010028 Date: 26-10-2005 10:10:06 Error Description: The Database cannot be opened. The database is opened by another user for exclusive use or the database does not exist. Error Number: 0 Error Source: _ProcessReport Line Number: 0 OtherSteps: I have tried 2 different ODBC drivers to no avail Linking from MS Acces to the system DSN is no problem |
|
Mark Pritchard
Oct 26th, 2005 - 6:47 PM |
Re: MARS cannot connect to the system DSN while MS Access can.
It looks as though the Access database that you are trying to execute the report from cannot be opened by MARS. Please try the following: 1. Exit out of MARS and stop the scheduler (if one exists) 2. Type Ctrl-Shift-Esc to bring up the Windows Task Manager 3. Go to the prcesses tab 4. Click on the "image Name" column to sort by name 5. Locate any instances of MSACCESS.EXE or MARS.exe and close them by clicking the "End Process" button 6. Restart MARS and try executing the schedule again. |
|
Pieter
Oct 26th, 2005 - 6:49 PM |
Re: MARS cannot connect to the system DSN while MS Access can.
This response was spot-on: altough not visible anymore, Msaccess.exe was still running in the process list of Windows. The reason it took so long to finally make it work after that was that i used file-based DSN's in my Access database. Not only did i have to create a system-DSN for Mars, i also had to redefine my Access database links from file-based DSN's to system-based DSN's, something i didn't learn from the description of the DSN Name field in the periodic report case evaluated in the support section of your website. Furthermore, every change in the definition of the system DSN's mandates a rebuild of the Access database links. After that everything works fine and i am impressed with the functionality, versitality and ease of use of Mars. 
|
| First |
Prev |
Reply |
Forum |
Next |
Last |