Pivot table and SQL cube

[Groningen]

Hello,

In VB I'm using a pivot table control wich is connected to the SQL server. I've completed the 'wizard' to connect to the SQL server and selected the cube. The pivot table generates the following error: cannot process the query, unknown error.
I haven't written any code yet.

Please advice me. Thanks!

[Groningen]

I'm using Microsoft Office Web Components and Microsoft ActiveX Data Objects 2.1 Library.
Does someone have a solution for my problem?