>Hello all,
>
>I apologize if this question has been addressed before.
>
>I'm having trouble trying to connect to MSOLAP from sql 2000. The provider is not listed when I run xp_enum_oledb_providers. We recently updated MDAC to 2.7. Has anybodyelse experienced this problem and resolved it?
>

xp_enum_oledb_providers extended SP doesn't show all OLE DB providers. It shows onle once that can be used with linked servers. See http://www.sqldev.net/faq.htm#FAQ:%20xp_enum_oledb_providers%20does%20not%20list%20all%20installed%20OLE-DB%20providers.