OWC 10 PivotTable Error on remote machines

[Hendrik]

Following up from the post here:
http://groups-beta.google.com/group...y+further+error+information"#825780fa398b2a3e

I am currently experiencing the similar error behaviour as described in
the post above, only to happen on remote machines.

So, we have a machine A running Win2000 Pro, hosting a webpage with OWC
10 Pivot Table control in it. It has a connection string as such:
Provider=SQLOLEDB.1;Password=pwd1234;User ID=userid;Initial
Catalog=databasename;Data Source=servername.
As for the CommandText, the value is: SELECT * FROM TABLENAME.
When we run the page on the machine A, the control works as expected.

However, when we try on another machine B accessing the page on machine
A, we can see the field list, we can drag and see the data when dragged
to Data section, but when we drag any of the field onto Row or Column
area, we get "Query could not be processed: The data provider didn't
supply any further error information" message.

All machines has Office XP SP-2 installed.

The solution given the post above of reinstalling SP3 to the SQL server
doesn't really make sense, as some machines are able to access the
pivot table correctly, even dragging the fields in Column or Row area.

Any clue on how to go about this?
Thank you so much

 

[Hendrik]

Hi all,

We managed to solve this problem, by installing Microsoft Office 2003
Web Components
(http://download.microsoft.com/download/c/f/f/cff746cd-f17c-40d8-acf2-50d2200ad28b/owc11.exe)
on the machines which exhibit this "anomaly".

Now we have the solution, but we still couldn't understand what causes
this problem.

Any take?