RE: Pivot diagram will not display on web page

From: Anthony D'Angelo (anonymous_at_discussions.microsoft.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 06:35:48 -0700

You are correct with both. If you do not want to use http
you can use a typical connection string from a rdl file.
>-----Original Message-----
>I have read a bit and realize I need file msolap.asp
installed in wwwroot. It
>seems I also need enterprise edition of SQL Server to
connect to a cube using
>http.
>
>Regards
>
>Tore G.
>
>"nospam@tgylnospam.no" wrote:
>
>> Web page with pivot diagram created in excel will not
display.
>>
>>
>> I have SQL Server 2000 with Analysis server, SP 3a. I
have created some
>> cubes and would like to display them as pivot diagrams
in web-pages. I do
>> this by creating a pivot diagram in excel and then save
as web page to
>> directory wwwroot.
>>
>> My platform is Windows 2000. The pages will finally be
deployed on a windows
>> 2000 server, but my current testplatform is windows
2000 professional
>> workstation. SQL Server, Analysis Server and client
are all on the same
>> workstation, all with the latest service packs.
>>
>> I have made two versions of the web-page. One version
is created by me
>> logging in on workstation as administrator. The other
version is created by
>> me logging in as power user.
>>
>> In Internet explorer I write the following in the
address field:
>> http://localhost/MyTestPageCreatedAsPowerUser.htm
>> Everything works fine and I can collapse and expand
columns and rows
>>
>> If I write
http://localhost/MyTestPageCreatedAsAdministrator.htm the
page
>> will not display. I open the web-page but the pivot-
diagram does not show.
>> However, If i click directly on the file in Windows
explorer the web-page
>> opens and pivot diagram displays correctly. When i
write http://localhost....
>> in internet explorer i guess I make use of IIS. My
guess is that some setting
>> in IIs is wrong????
>>
>> I cannot figure out why the two pages behave
differently. Security settings
>> in IIS and Windows Explorer and SQL Server 2000 /
Analysis server seem to be
>> the same for all files and roles (power user and
administrator).
>>
>> Regards
>>
>> Tore Gylver
>>
>>
>.
>

Relevant Pages

  • Re: Using Microsoft update on Windows Server 2000 sp3
    ... In my case the Windows 2003 Server is a Domain server and doesn't have ... >> To save changes to your settings for this website, ... >> userdata persistence for Internet Explorer. ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Task scheduler error in W2003
    ... The W2003 server is a secondary domain controller on our network and I ... "Note that this problem occurs only when you install Internet Explorer ... Scheduler add-on." ... This is a Windows 2003 Server and not NT4 ...
    (microsoft.public.windows.server.general)
  • Best Practice
    ... Administer use server to browse the web is safe and your server have Windows ... If you don't use Windows Server 2003's Internet Explorer Enhanced Security ...
    (microsoft.public.security)
  • Re: Current Version of IE
    ... Internet Explorer 5.01, Internet Explorer 6, Internet ... Explorer 6.0 for Windows Server 2003, Internet Explorer 6.0 for Windows XP ... Windows NT Server 4.0, Windows NT Server 4.0, Enterprise Edition, Windows NT ... Unfortunately the latest security patches have not been ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Pivot diagram will not display on web page
    ... Web page with pivot diagram created in excel will not display. ... I have SQL Server 2000 with Analysis server, ... My platform is Windows 2000. ...
    (microsoft.public.office.developer.web.components)