Microsoft OLE DB Service

[L Gilroy]

After having installed Office XP, I noticed that Excel did
not contain any OLE DB Service Provider for OLAP. I'm led
to understand by a support agent for a piece of software
that I need this feature for that it's supposed to be.

I of course was under the impression that Pivot Table
Services installed this feature.

Both of these things have been installed, but neither of
them is giving me the OLAP Provider.

Help is greatly appreciated.

 

[Jamie Collins]

...

After having installed Office XP, I noticed that Excel did
not contain any OLE DB Service Provider for OLAP.

I just now created a virtual machine with Win2000 Professional and
OfficeXP. If I run the following code in an Excel macro I see the OLAP
provider in the list:

Sub test()
Dim oDLink As Object
Dim strNewConnection As String
Set oDLink = CreateObject("DataLinks")
On Error Resume Next
MsgBox oDLink.PromptNew
End Sub

Jamie.

--