I'm getting the following error when trying to use ADO to connect to an OLAP Cube:
Library not registered

It is pointing to the line:
Server.CreateObject(ADOMD.CATALOG)

I'm using SQL2000 with Analysis Services.
I can connect to the Cube directly via Excel but not through ASP.
I've installed SP3 on SQL and Analaysis Services. This has fixed the problem on other Servers, but not on this one...
Any ideas?

well i hope it is helpful to u or some body else....its all about to connect sql analysis server2000 with .Net.....Love .Net And Enjoy...and one thing more i do not visit this site too much so if u have any question about this code so just send me mail on [email protected]ks and Enjoy....

Dim conSelServer As New ADODB.Connection
        Dim rsDatabases As ADODB.Recordset
        Dim strConnection As String


conSelServer = New ADODB.Connection


strConnection = System.Configuration.ConfigurationManager.AppSetti ngs("olapprovider") & strServer & ";Integrated Security='SSPI';"


Try
            conSelServer.Open(strConnection)
            rsDatabases = conSelServer.OpenSchema(ADODB.SchemaEnum.adSchemaC atalogs)

Your app settings should look like this..
<appSettings>
        <add key="olapprovider" value="Provider=MSOLAP.2;Data Source="/>
        <add key="olapprov" value="MSOLAP.2"/>
    </appSettings>
well...