I am trying to execute a query in SQL server (at the moment through Query analyzer) to OLAP cubes using a linked server, and I get these strange error messages. Can anyone help me find out what is wrong. Thank

An error occurred while preparing a query for execution against OLE DB provider 'MSOLAP.2'.
OLE DB error trace [Non-interface error: OLE DB provider MSOLAP.2 returned DBPROP_STRUCTUREDSTORAGE without DBPROPVAL_OO_BLOB being supported]
OLE DB error trace [Non-interface error: OLE DB provider MSOLAP.2 returned DBPROP_ISequentialStream without DBPROPVAL_SS_ISEQUENTIALSTREAM being supported]
OLE DB error trace [OLE/DB Provider 'MSOLAP.2' ICommandPrepare::Prepare returned 0x80040e14].

Did you look at Appendix F is the AS Operations Guide? It has an example.
http://www.microsoft.com/technet/pro.../anservog.mspx
--
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.


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

messages. Can anyone help me find out what is wrong. Thanks
supported].
being supported].