Which ADOMD.NET?

Question

I am building an application that will send MDX queries to a SQL Server 2008 Multidimensional database. First it seems that the client assemblies needed to build such a .net application are not installed with the SQL 2008 Client Tools. Next there seems to be a wide variety of versions that can be downloaded. What is the "latest"?

Thank you.

Kevin

Answer 1

Hello Kevin,

You can get AdoMD.Net as a separate installer from Mircosoft SQL Server 2008 R2 Feature Packs, that's the newest one. There are 3 different version for the 3 different types of OS: x86,x64 and IA64.

---

Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de

Answer 2

Hi Kevin,

If you are building .Net application and through that if you want to connect to SQL Server Analysis Services 2008 then you will need Microsoft.AnalysisServices.dll (version 10....) Download it from http://www.microsoft.com/downloads/details.aspx?familyid=228de03f-3b5a-428a-923f-58a033d316e1&displaylang=en under Microsoft Analysis Management Objects. After installation you will get Microsoft.AnalysisServices.dll under C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies.

For Microsoft.AnalysisServices.AdomdClient.dll you will need to download Microsoft ADOMD.NET. after installation you will find the dll under C:\Program Files\Microsoft .Net\100

Regards,

 

 

---

Ani