Solved

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

Posted on 2008-06-25
15
642 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
 

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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

762 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now