Unexpected error when populating MDX functions collection

Question

Post reply

Unexpected error when populating MDX functions collection

Jeremy Kemp

SSCertifiable

Points: 6754
More actions
April 28, 2004 at 2:27 am

#179620

I am getting this message every time I connect to a DB using the MDX Sample Application:

Unexpected error when populating MDX functions collection
Object or provider is not capable of performing requested operation.

Any ideas?

Jeremy
May 3, 2004 at 8:00 am

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 1

sp3/3a on both client and server? Sounds a little like a MDAC problem.

Steve.

Yulin Chen Grasshopper Points: 17 More actions · Answer 2

I encountered this problem also, sp3 on both client and server.

Any help is appreciated!

Thanks,

Yulin

Yulin Chen Grasshopper Points: 17 More actions · Answer 3

I have got the answer. Input "msolap.2" into the provider textbox. This is caused by OLAP providers are more than 1.

maria-152802 SSC Enthusiast Points: 187 More actions · Answer 4

This works a charm!! But I am unable to view my cubes still ...

If i select the FoodMart 2000 database, all it's cubes appear. But my own custom cubes (in my custom database) just don't appear. they used to, but suddenly they don't.

Also, when i open up Crystal Reports and try to look at these custom cubes, same problem! the error i get there is: "Failed to open OLAP database"

Jamie Thomson SSChampion Points: 11805 More actions · Answer 5

Definitely sounds like MDAC.

Use component checker (see link) to see what version of MDAC you have and, if necassary, reinstall.

http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en

You may find that you have disparate parts of MDAC versions in which case the best course of action is to reinstall. All the executables for reinstalling are downloadable from Microsoft.

I think the minimum version you need is 2.5

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson

maria-152802 SSC Enthusiast Points: 187 More actions · Answer 6

Thanks so much for your reply!! I followed your advice and ran the component checker on my PC. It came back with MDAC 2.7 SP1 and MDAC 2.7 SP1 REFRESH. ((sob)).

still getting the same problem unfortunately. i can't get my head around why it used to work, and then why it suddenly stopped. I reinstalled both Analysis Services AND Crystal Reports.... any ideas what else it could possibly be?

Thanks in anticipation

Maria

Yulin Chen Grasshopper Points: 17 More actions · Answer 7

Creating a Security Role which allows everyone to access the cube.