ADOMD and XML/A

Hi,

I got the following from a Microsoft Technet Chat - "The advantage of XML/A over ADOMD is the thin client. ADOMD requires PTS and ADOMD installed on all client machines while XML/A would only require an XML parser."

Now say, I develop an asp.net application which would use adomd.net to get cube data, and will also run mdx queries. I host the asp.net page on my server, and allow it to be accessed by remote users. My server itself contains all the necessary cubes, and other components like adomd.net, etc.

My question is, if you want to run the asp.net page hosted on my server, (via HTTP), will it be necessary for you to install the adomd.net components on your local (remote) machine also?

(Actually I dont like coding with XML/A and find execution of mdx queries via Adomd.Net much easier! Any links showing xml/a coding for MDX in VB.Net from scratch?)

Thanx and Regards!

As in typical ASP.NET apps, you only need data access components on the ASP.NET server - maybe the 2nd figure on this page will help you:

http://msdn2.microsoft.com/en-us/library/ms174518.aspx

>>

SQL Server 2005 Books Online

Client Architecture (SSAS)

...

Analysis Services provides broad middle tier support for Web services. ASP applications are supported by OLE DB for OLAP and ADO MD, ASP.NET applications are supported by ADOMD.NET. The middle tier, illustrated in the following figure..

>>