New Information - SQL Server 2000 SP3.
You can use PivotTable® Service using either Microsoft® ActiveX® Data Objects (ADO) and a COM Automation language, such as Microsoft Visual Basic®, or the COM interfaces provided by OLE DB for OLAP using Microsoft Visual C++®.
Microsoft SQL Server™ 2000 Analysis Services and PivotTable Service implement the OLE DB for OLAP 2.0 specification.. For more information about OLE DB for OLAP, see the OLE DB documentation.
However, PivotTable Service is not fully compliant with OLE DB for OLAP and introduces new functionality that is not included in the specification. For more information, see OLE DB Compliance.