Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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

Symptom

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

1.jpg

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: ADOMD.zip.

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. Note that you may also need to enable the .NET Framework as described here

.

Published:

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

Symptom

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

1.jpg

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: ADOMD.zip.

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. Note that you may also need to enable the .NET Framework as described here

.

For an optimal Community experience, Please view on Desktop