I understand that a lot of people have asked the same type of questions
in this site. I have set up an olap cube that users access using a html
page with an OWC object embedded to it. So far, the intranet users can
access to the cube but the internet users cannot. I have read posting at
this web site and Dave Wickert's article at
http://msdn.microsoft.com/library/de.../en-us/dnsql2k
/html/sql_datapump.asp numerous times. I have set up msolap.asp and
msmdpump in the iis. I have also include the anonymous internet user in
the role of the cube. But still have no success. The only difference
between my setting and the rest of successful stories in this web site
is that I am using Win 2003 Server.

My configuration is as follows:

Windows 2003 server
SQL Server 2000 sp3
Analysis Service sp3
IIS, SQL, AS all reside at the same server
Server resides behind router

My javascript code in the html page to initiate pivot table is as
follows:

Form1.mgPivotTable.ConnectionString = "Provider=MSOLAP;Persist Security
Info=False;Data Source=http://public_ip_address/myOlap;Initial
Catalog=myDataBaseName";
Form1.mgPivotTable.DataMember = "Cube_Name";

I have configured the router to redirect all http and https traffic to
our public ip address to this server. When the user accesses to the
cube, the second line of the above code returns a "Not Find" error.

What have I missed here? Please help me.

Chris Li




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Dave, Thank you for your reply. You make a good point. 2 other asp.net
applications are running in this server and therefore, I assume that asp
is working too. But I will make a test when I have a chance.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Dave:

I have enabled asp in the 2003 server and the "not found" error is gone.
But the html client still does not get any result back from the server
after a long wait. Do I need to enable something else in the server.

Please help!

Chris Li



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I cannot perform this test because your code text is too long and it is
cut off in the middle. Also I don't have owc10. I have office 2000 which
include owc9.

I did try to connect to the Foodmart 2000 using my html page but without
success. There is no error message. The client page keeps requesting for
extended time and no data returns. But all these works inside the
intranet.

If you would, please resend your code for the test page.

Chris



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Chris;

If i were you, i would look into using this with the latest version of
Office 2003-- the Web Components are VASTLY improved.

you can sort, do all sorts of neat things




"Chris Li" <chrisli888 (AT) yahoo (DOT) com> wrote

That is out of the question. We don't have budget to upgrade office 2000
to office 2003.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!