Accessing SAP provider via OLE DB for OLAP

[Mike McLaughlin]

Hello -

I am attempting to programmatically retrieve the Cubes schema rowset
from an SAP provider.

I perform the IDBSchemaRowset->GetRowset with MDSCHEMA_CUBES to get the
Cubes Rowset object, perform some other setup, and then try to call the
GetNextRows method of the Cubes Rowset.

However, I am returned "No Interface" error code. (hr = -2147467262).
Does anyone have any thoughts on what the problem could be. I'm not
sure what interface that error is indicating.

Note that this code works successfully against Microsoft and Applix
providers.

Any help would be appreciated -

Thanks
Mike

[Alan Jackson]

Code that I have written works in the same way against all providers that I
have tested it with and works for all.
What version of the BW are you using?

Regards
Alan

Mike McLaughlin <mmcl...@comshare.com> wrote in message
news:38C7FE2E...@comshare.com...

[Mike McLaughlin]

It is version: 1.2b Patch 13.

Thanks
Mike

[Microsoft Developer Support]

Hi Mike,

I'm David with Microsoft OLAP support, in regards to your question on the
SAP Provider and getting the SchemaRowset it looks like a problem in the
provider and not what you're doing in the code. I would also check with
the vendor of the provider to make sure there isn't a problem with provider.
The error indicates exactly what it states "0x80004002 -2147467262 No
such interface supported". Also make sure the provider is registered
correctly and that all supporting DLL's exist.

I hope this helps.

David
Microsoft OLAP Support

[ppavan...@gmail.com]

On Thursday, March 9, 2000 1:30:00 PM UTC+5:30, Mike McLaughlin wrote:
> Hello -
>
> I am attempting to programmatically retrieve the Cubes schema rowset
> from an SAP provider.
>
> I perform the IDBSchemaRowset->GetRowset with MDSCHEMA_CUBES to get the
> Cubes Rowset object, perform some other setup, and then try to call the
> GetNextRows method of the Cubes Rowset.
>
> However, I am returned "No Interface" error code. (hr = -2147467262).
> Does anyone have any thoughts on what the problem could be. I'm not
> sure what interface that error is indicating.
>
> Note that this code works successfully against Microsoft and Applix
> providers.
>
> Any help would be appreciated -
>
> Thanks
> Mike

Hi Mike McLaughlin,

I am also writing ODBO provider for getting list of cubes and data in Excel,
So can u help me in that , i am from dot net ,but for this i am using c++, so can u share your code or some tips , so that i can complete my task.