I've set up a cube with SQL Server 2000 Analysis Services. That part
works perfectly and has the exact data that I need. Now, I want to be
able to do simple MDX queries against this and dump the results to a
web page. I'm looking for ease of development over features at this
point.

I've downloaded the "XML for Analysis 1.1" and "ADOMD.NET 8.0" SDKs and
they are... (searching for the right words) unfinished, pre-beta
quality, and I suspect they are obsolete and abandoned.

The "ADOMD.NET 8.0" sample project needed to be upgraded to run with
Visual Studio 2003 (very strange for a download released on 5/4/2005)
and then needed significant work to run correctly. It kept insisting
that I install .NET framework 1.0 when I only have .NET 1.1. After
getting passed that, I still get "An error was received from the
provider while connecting: ". When looking in the debugger, I see the
ADOMD.NET API throws a AdomdErrorResponseException with a blank
message.

The XMLA 1.1 WSDL file doesn't work correctly with Visual Studio's 2003
"Add Web Reference".

I have read dozens of articles, whitepapers, and websites on this
topic. I have found *lots* of theoretical commentary but a dearth of
actual working sample code.

Unfortunately, SQL Server 2005 isn't an option for me. I'd love to try
it but business reasons prohibit that.

Has anyone had any kind of success at this? Does anyone know which SDKs
to use and which to avoid? I've spent many hours on this and am really
lookign to get something running.

Thanks!

If all you need is to do some MDX queries and send results to the Web page,
perhaps you can take a look at Reporting Services, which allows you to do
exactly that.
Or, if you insist on building your own solution, you don't need XMLA. You
can do it with either ADOMD or ADOMD.NET
Here are some links to source code samples:

http://www.microsoft.com/downloads/d...DisplayLang=en
(uses ADOMD)
http://www.sqlserveranalysisservices...tGridIntro.htm
(uses ADOMD.NET)

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
<Gamigin (AT) gmail (DOT) com> wrote