Query could not be processed

[Dan Slaby]

I added a pivot control to an ASP.NET page. When I run the page and add a
field to the rows and columns, I get the error message that the "query could
not be processed. The data provider didn't supply any futher error
information." Does anyone have an idea why the pivot table is unable to
process the query? It works on my development machine. Thanks for any
suggestions.

Dan

 

[Wei-Dong XU [MS]]

Hi Dan,

Based on my experience, your connection string of the pivottable to the
data source may not have the username and password. Then the pivottable
control can't successfully link to the OLAP data source and reported this
error. There is one kb article introducing this issue:
325617 PRB: Access Denied When You Access OLAP Server Over HTTP with Office
Web Components
http://support.microsoft.com/default.aspx?scid=kb;EN-US;325617

Please feel free to let me know if you have any further question on this
issue.

Best Regards,
Wei-Dong XU
Microsoft Support

 

[Dan Slaby]

I checked the "Allow saving password" in the connection string; Where is the
connection string stored so I can verify it?

 

[Wei-Dong XU [MS]]

Hi ,

There is one property ConnectionString of the pivottable control. We could
use this to specify the connection string and embed the username and
password in the connectionstring. This is just like our connection to the
normal SQL datrabase. The format should be:
"Provider=MSOLAP.2;UID=TestUser;Password=Test;Data Source=http://<OLAP
server>;Initial Catalog=FoodMart 2000"

Please feel free to let me know if you have any further question on this
issue.

Best Regards,
Wei-Dong XU
Microsoft Support