Error: An unexpected error has occurred: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=9.0.242.0... – Support Topics

Symptom

When a user is trying to access the OLAP cubes in Excel by using Jet Reports, the following error message is displayed:

Excerpt text from the error message:

An unexpected error has occurred: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Cause:

This is caused by the required ADOMD.NET client not being installed. The client is normally installed automatically during the installation of the Jet Excel add-in but, if this error comes up, the installation was blocked and the client must be installed manually.

Resolution

Download and install the correct version of the ADOMD.NET client from the download link at the bottom of the page on the client machine.

The SQL 2005 version of the ADOMD.NET client should be installed regardless of the version of SQL that is being used at the client's organization. The Jet Excel add-in will specifically look for this version.

The version of the ADOMD.NET client matching the client machine's operating system (32-bit or 64-bit) (not Microsoft Office version) should be downloaded and installed.

Please note that you may also need to enable the .NET Framework as described here.

Updated March 05, 2020 22:35: Harry Lewis

Symptom

Resolution

Comments