I have created a cube in Analysis Server. The cube is accessed through a VB front end app which calls a stored procedure with various parameters. In this stored procedure I use the select * from openquery(...) statement to return a flattened rowset from the cube. I then return the recordset to VB, and display the results in an Excel spreadsheet. This is all working until more than one user triggers this process at the same time! I am getting the cryptic "OLE DB provider 'MSOLAP' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'MSOLAP' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.]." error message. Is this a limitation of the openquery statement?