Can OWC PivotTables use SHAPE'd data?

[Andrew]

I have the following OWC Pivot table in a webpage:

<object id="pTable" classid="CLSID:0002E55A-0000-0000-C000-000000000046">
<param name="connectionstring" value="Provider=MSDataShape;Data
Provider=SQLOLEDB;Server=MyServer;Database=MyDatabase;User
Id=ABC;Password=XYZ">
<param name="commandtext" value="... See below ...">
</object>

I have tried the following two values as command texts, but both of them
cause the OWC to indicate that a provider syntax error or access violation
occurred. However, both are entirely valid commands.

1.
SHAPE {select * from Task}

2.
SHAPE {select * from Task}
APPEND (
{select * from TaskActivity} AS chapter RELATE ID TO TaskID
)


If I use the simple statement,

SELECT * FROM Task

then the OWC Pivottable works.

Can anyone tell me if there is something I'm missing or if SHAPE'd data is
not supported?

Thanks, Andrew