I am trying to use the OWCMDX.dll (an unsupported DLL that ships with
SQL Server 2000) in order to assign MDX queries directly to
PivotTables (Microsoft XP Office Web Components). I imported the dll
into a .NET Windows Forms application using Visual Studio's Interop
support. When I attempt to execute the following code:

ApplyMDX amQuery = new ApplyMDX();
string mdxQuery = "<valid MDX query>";
amQuery.ApplyMDX((object)pivotTable1, mdxQuery);

I get the exception : "No such interface supported".
Exception details:
[System.InvalidCastException]: {"No such interface supported" }
System.Object: {System.InvalidCastException}
_className: null
_COMPlusExceptionCode: -532459699
_exceptionMethod: <undefined value>
_exceptionMethodString: null
_helpURL: null
_HResult: -2147467262
_innerException: { }
_message: "No such interface supported"
_remoteStackIndex: 0
_remoteStackTraceString: null
_source: "Interop.OWCMDXLib"
_stackTrace: {System.Array}
_stackTraceString: " at OWCMDXLib.ApplyMDXClass.ApplyMDX(Object
pctrl, String bstrMDX)

I have registered the Active X object using REGSVR32.exe.

Any help/suggestions will be greatly appreciated!

Thanks,

Since OWC11's PivotTable supports a CommandText property, there is no