How to add reference of ADOMDClient

Hi,

I am using WinPivotGrid control ver 15.2 in my project. It requires the dll Microsoft.AnalysisServices.AdomdClient.dll to be added in my project. but, its not provided in the package. And also which version of ADOMDClient dll this control support? when I searched over internet this dll is available in version 10,11, and 12

Hi Nitin,

    No, we do not provide that dll as it is a Microsoft DLL, and it would be dependant on the version of SQL Server that you are using or connect to. I do not see specifically in our documentation what veersion we support, but my guess is that we do support all of the current ones as 12 is based on SQL Server 2012, and our control came out in 2014. Although the sample from our samples browser is using 11. From a StackOverflow question, below I was able to get a download site for the dll, but again I believe it is dependant on what you are connecting to, so check with your server or DB admin to verify.

http://stackoverflow.com/questions/23605901/adomdclient-missing
http://www.microsoft.com/en-us/download/details.aspx?id=29065

Also below is a link to our help demonstrating using PivotGrid with an ADOMD datasource
http://help.infragistics.com/doc/WinForms?page=WinPivotGrid_Using_ADOMD.html

Let me know if that works for you,

Hi,

Thanks for the response.

I have version 11 for Microsoft.AnalysisServices.AdomdClient.dll installed on my development box. When I tries to run a simple program having windows pivot and MDX selector control, the pivot control shows no data and doesn't give any error.

But, when I selects "All Common Language Runtime Exception" from Debug->Windows->Exception Settings, then at runtime it gives error :

Exception thrown: 'System.IO.FileNotFoundException' in Infragistics4.Olap.DataSource.Mdx.v15.2.dll

Additional information: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

To fix this issue I have explicitly installed version 10 of Microsoft.AnalysisServices.AdomdClient.dll. 

That's way I asked whether there is any hard dependency on this version of dll? Can you please confirm again if there is any dependency and if yes then what is the best way to resolve this issue?

Hi Nitin,

     As I said, our samples, at least on my machine it is using version 11. Also I even doubled checked the actual project file of that assembly, and the reference has SpecificVersion = False. As to why it is looking for 10, I am not sure. There are a few possibilities, but let's see if we can resolve your first error. When you drop on the PivotGrid on the Design surface it should add the following DLL's.

Infragistics4.Olap.Core.v##.#
Infragistics4.Olap.DataProvider.Adomd.v##.#
Infragistics4.Olap.DataSource.Flat.v##.#
Infragistics4.Olap.DataSource.Mdx.v##.#
Infragistics4.Olap.DataSource.v##.#
Infragistics4.Olap.DataSource.Xmka.v##.#
Infragistics4.Shared.v##.#
Infragistics4.Win.UltraWinEditors.v##.#
Infragistics4.Win.UltraWinPivotGrid.v##.#
Infragistics4.Win.UltraWinTree.v##.#
Infragistics4.Win..v##.#

If you manually added the dll's and created the PivotGrid in code, and left off a few of the assemblies that could be a reason why you are having the missing assemblies errors. Just so that I can possibly rule out different issues. Are all the assemblies local to your development machine? Was our product installed locally on your development machine with the assemblies in the GAC.