FoodMart Example -- sql server reporting services

Cem Demircioglu
7/26/2004 4:56:44 PM

Hello,
Today is my turn to ask a question. :)

I first installed SQL 2000 Dev (3a) and then RS with SP1. Everything is
working great, except foodmart example. Today I installed analysis services
with Foodmart database. However still I can't see the Foodmart example
report. In VS, when I click on Data tab, the following error message pops
up. "A connection cannot be made to the database. Set and test the
connection string. The MSOLAP.2 provider is not registered on the local
machine."

What do you think guys?

Thanks.

Regards,
Cem

Cem Demircioglu
7/26/2004 5:47:56 PM

Got it working guys. FYI.

First I had to register two dlls, msolap and msolap80 under
%system root%\program files\common files\system\ole db
regsvr32 msolap.dll
regsvr32 msolap80.dll

Then I created a new datasource using MS OLEDB Provider for OLAP services.
After changing the datasource of queries, Foodmart example start to work
properly.

Thanks.

Regards,
Cem

[quoted text, click to view]

sql server reporting services : FoodMart Example