Power Monitoring Expert Diagnostics Viewer displays "Could not load file or assembly 'ADODB, Version=7.0.3300.0"

Issue
When attempting to open the Diagnostic Viewer, the following message is displayed "could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b0315f7f11d50a3a' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference HRESULT: 0x80131040". The error in Diagnostic Viewer looks like image shown below:




Product Line
Struxureware Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x

Environment
Diagnostic Viewer

Cause
Occurs in a distributed system when the wrong version of adodb.dll is placed in the Power Monitoring Expert/system/bin directory.

Resolution
*Warning: Take backups of any files prior to modifying them. Ensure the backups are in a location that will not be overwritten (i.e. the Desktop).*

1. On the database server, navigate to the C:\Program Files (x86)\Microsoft .NET\Primary Interop Assemblies\ folder
2. Copy the adodb.dll file
3. On the Database server, navigate to the Power Monitoring Expert\system\bin folder and back up the existing adodb.dll file already present. Then, place the adodb.dll file from step 1 into this folder.
4. Next, navigate to Power Monitoring Expert\system\bin folder on the Application Server and back up the existing adodb.dll file already present. Then, place the adodb.dll file from step 1 into this folder.

Released for:Schneider Electric USA