We're trying to run an ASP application that accesses an OLAP cube, but we're running into some provider problems.
Here's the example we used (Data Source and Initial Catalog were changed to match the cube's location and name).

------------------------------------------------------------------------------------------------------------------
Dim MyCellSet As New ADOMD.Cellset

MyCellSet.ActiveConnection = "Provider=msolap; Data Source=LocalHost; Initial Catalog=FoodMart;"
.....
------------------------------------------------------------------------------------------------------------------

However, when we run the app, we get an error on the ActiveConnection line:
------------------------------------------------------------------------------------------------------------------
ADOMD.Catalog error '800a0e7a'
Provider cannot be found. It may not be properly installed.
------------------------------------------------------------------------------------------------------------------

We are running Windows 2000 with MDAC 2.7 installed. We do not have SQL Server installed on this machine. My assumption was MDAC 2.7 would contain the MSOLAP provider, but with this error, I have second thoughts.

Is there another install we need to run to get this to work?

Hello,
If you are running the asp application on the same server of analysis
services (I assume by the data source localhost), try to install the latest
AS 2000 service pack, it will fix the provider. You can download it here

http://download.microsoft.com/downlo.../sql2kasp3.exe


Have you Visual Studio.NET or Office XP developper install sometime it broke
the msolap provider,

Best Regards,

Patrice
"AD" <anonymous (AT) discussions (DOT) microsoft.com> wrote

the MSOLAP provider, but with this error, I have second thoughts.

You need to install PTS on your machine. It is the OLEDB Provider for OLAP.
You can get a distribution by going to your SQL Server 2000 AS SP3
distribution and looking in the folder \msolap\install\PTS and selecting
either ptsfull.exe or ptslite.exe. PTSLITE.EXE is just the OLEDB Provider.
PTSFULL.EXE is the full MDAC stack.

Hope that helps.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"AD" <anonymous (AT) discussions (DOT) microsoft.com> wrote

the MSOLAP provider, but with this error, I have second thoughts.