Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rip.murdock
Starting Member
4 Posts |
 Posted - 2005-08-31 : 20:58:46
|
| I’m trying to issue a refresh cube command to Analysis Services from SQL Server prior to issuing an MDX query.When I use OPENQUERY like so,SELECT * FROM OPENQUERY(mylinkedserver, 'Refresh Cube C7')I get this error:OLE DB provider 'MSOLAP.2' reported an error. Command was not prepared.OLE DB error trace [OLE/DB Provider 'MSOLAP.2' IColumnsInfo::GetColumnsInfo returned 0x80040e4a: Command was not prepared.].Any ideas on how I should prepare the command? |
|
|
|
|
|
REFRESH CUBE command to Analysis Services from SQL