The code cycle is broken when it tries to load the data from database. The data itself is correct, but the code fails when we use ADO(part of MDAC) to interpret it. There seems nothing wrong at database side.
The error is as follows in our log file: "TDtGlobalSettings.LoadSettingsFromDatabase(). Caught exception: Invalid argument"
You will also see ADO errors in the Logs.
This is sometimes caused by a corrupt MDAC.
There are many ways to reinstall MDAC, however, you must be careful that you do not install a version that will no longer work with certain applications that may be dependant on the current version, such as Antivirus and such. To find your version of MDAC, Microsoft has a utility called MDAC Checker that can be downloaded from the same location as the MDAC versions.
Please find the version that you currently have installed, and reinstall this version using the following steps.
1. Uninstall SOE.
2. Download the current version of MDAC from Microsoft and install it.
3. Reinstall SOE.
4. try to reproduce the problem.
If this does not resolve the issue, please contact Quest Support.
