Access to MDX using .NET Question.

[Nassy]

Hi all,

I am a relative newbie to the world of .NET and am trying to write an OLAP application using the ADOMD sdk - COM version.

For example I am using the following statements in my code



Imports ADODB
Imports ADOMD
Imports System.Data.OleDb

Dim cn As New ADODB.Connection
cn.Open("provider=msolap;data source=MyServer")
cn.DefaultDatabase = "MyAnalysisDatabase"



When I run this I get an error message saying that the
MSOLAP provider cannot be found.
I have looked into this issue a little bit deeper and realise that .NET is looking for a file msolap.asp which it can't find.

The problem I have is I need my .NET script to be able to access a cube that is on a remote server whereas the article I have read about using the msolap provider suggests I need Analysis Services to be running on the same machine as IIS.

Is there another provider I could use that would not have this constraint?

Any help much appreciated on this as with these sorts of things it can be quite hard working out where to start!

Thanks

Nassy