Office Web Components PivotTable in .NET ASP works in localhost, not in other client machines
Posted on 2008-06-25
Hi! I've an asp page with an Excel spreadsheet and graphics (PivotTable). In the server in which is installed, everything works fine, but in any other machine in my network or in the Internet, it doesn't work.
First of all, it always display message that I need to add the site to my trusted sites, off course I've already done this.
The first time of login, I need to install the OWC on the client machines, once done this, I see the components but empty.
The graphics part of my page tell that it was an error getting the data, the errors returned from the provider are lower, and of course no graphic is displayed.
document.PivotTable1.ActiveView.RowAxis.FieldSets("UNIDAD").Fields("UNIDAD").IncludedMembers = sarrMemberShow;
As I said, it works perfect on the server that is hosted, but didn't on any other machine, and in any other machin keeps telling to add it to trusted sites, and the errors described above.
The server is a Windows XP Professional, running SQL Server 2000 and Analysis Manager. It also has Office 2003, and has installed OWC 10 and OWC 11. No firewall is blocking the ports, as I have disabled everything that I can think could be affecting.
Please help me, I'm two weeks over schedule on this!