Skip to Content
Former Member
Mar 13, 2011 at 07:22 PM

SAP BW OLE DB provider in Excel, no connection and unknown error



My plan is to connect Excel to an SAP BW, but it's not working.

I installed SAP GUI 7.10 and using the SAP Login I can access the system, so the credentials are correct.

in the settings dialog of the OLE DB provider I tried all combinations I could think of:

as data source string: 1.the ip of the system 2. the same name as the connection entry in the SAP Login 3. the url 4.system ID and so on,

the same for the location string.

But all I get is an empty error window, cklicking on details shows this:


Error Group




and nothing else.

We need to get this up and running, so does anybody have a hint what else I could try ?