Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Office Web Components PivotTable in .NET ASP works in localhost, not in other client machines

Posted on 2008-06-25
15
645 Views
Last Modified: 2012-08-14
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.
I've a javascript that filters some of the information being used, when I click on it, I get a "permission denied" in a line that is:

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!
0
Comment
Question by:LAERION
  • 8
  • 7
15 Comments
 
LVL 20

Expert Comment

by:jitganguly
ID: 21885758
0
 

Author Comment

by:LAERION
ID: 21889034
Hi jitganguly. I saw the page, it works for static components, which are really just images that the server sends to the client. In this case, I need the interactive functionallity, so a user can customize his/her spread sheet, graphics, etc.
But thanks a lot for the help anyway :)
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 21891553
Laerion,
OWC works that way. It generates the file on the server and sends it to client. You cannot use OWC for what you want to do.

I would rather use excel to achieve that
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:LAERION
ID: 21892702
As I've read, the OWC works in two different ways. One is as a static one, serving only images, and the other as an interactive one, serving COM ojects like spreadsheets, graphics, etc. In fact, the link that you provided above, mention this two approaches, and the author of that link, teaches how to work with the static approach not the interactive one.

I've see it working this way, interactive, that's what I know what I want to do. Thanks a lot for your time :)

Best regards.
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 21894537
Well, I am not aware of it. Since you have seen it there must be the way. In the past I have used owc by generating file on the server and send it to client.

But why can't you opt for excel automation.
0
 

Author Comment

by:LAERION
ID: 21895212
Where can I read more about opt excel automation as you say? May be it does what I need. Thanks a lot for your help!
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 21898937
http://msdn.microsoft.com/en-us/library/aa701256(office.11).aspx
http://www.beansoftware.com/asp.net-tutorials/generating-excel-reports.aspx

Just check once you output to excel, if you could edit ? I think thats your objective, right ?
0
 

Author Comment

by:LAERION
ID: 21901584
Hi again and thanks for your help! What you put is closer to what I want, but still I think is not. To clarify the situation, I will take some screenshots of what I want to calrify my question. I'm gonna put it in about two hours. Thanks a lot for your help.
0
 

Author Comment

by:LAERION
ID: 21910904
I'm back. I will attach zip file containing two images with some screen shots of what I'm doing on localhost. In the same document comes a little explanation of what I do on that web page and the results.

Thanks a lot!
presentacionee.zip
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 21911145
What error are you getting now ? Looks like its javascript issues.

Can you post your code please ?
0
 

Author Comment

by:LAERION
ID: 21911388
I'm uploading the source of the page and a jpg with the javascript error, its a permission denied in an object.

Just to mention it again, the site is in the "trusted zone" of the IE, and I have Office 2003 and the OWC installed.

I'm attaching also the print screen of what is displayed in a remote computer.


1-1-vta-unidadG-1-.txt
permissiondenied.jpg
error.jpg
0
 

Author Comment

by:LAERION
ID: 21911405
If you don't know spanish, let me translate what th error.jpg window says:

"No details"
"The request cannot be processed or the data provider has not given additional info about the error"

And the javascript error says:

Permission denied,on line 126, character 3, code 0, of the third file I'm attaching.

Thanks!
0
 
LVL 20

Expert Comment

by:jitganguly
ID: 21911478
I know only Ola and gracious :-)

http://www.google.com/search?hl=en&q=Unable+to+connect+to+the+Analysis+serve

Google search came up with these pages. I am off for the day (in EST). See if you could fix it. you problem is it is not finding the server.

try some of the posts mentioned e.g.

Control Panel/Administrative Tools/Services.
Stop the SQL Server Analysis Services service.
Navigate in Explorer to the database directory where the Analysis Services databases are stored (usually C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data).
Delete the file TFSWarehouse.0.db.xml and the directory TFSWarehouse.0.db
Start the SQL Server Analysis Services service.
See if you can now connect to the Analysis Services in SQL Server Management Studio (Object Explorer/Connect/Analysis Services/your server name). Typically there will be no Databases listed at this point.
Click the Retry button on the setup screen.
0
 

Accepted Solution

by:
LAERION earned 0 total points
ID: 21912612
I've finally have the answer, and are two:

1) Install the OWC11.msi
2) Put the site in your trusted zone
3) Customize the trusted zone security level and activate the option "access to data source between domains"

And voilá!

Hopes ths works for some one, regards!

P.D. Thanks very much for your help jitganguly :)

0
 
LVL 20

Expert Comment

by:jitganguly
ID: 21915862
Great. Glad I could help you.

All the best...
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JavaScript can be used in a browser to change parts of a webpage dynamically. It begins with the following pattern: If condition W is true, do thing X to target Y after event Z. Below are some tips and tricks to help you get started with JavaScript …
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question