Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    May 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Office Web Components (OWC)

    Hi,
    I try to make a dynamic Pivot table (reading from Oracle)
    using Office Web Components (OWC) - Office 2000.
    I try to "start" from an example: OWebComp.exe
    from microsoft site
    (http://support.microsoft.com/support...SRCH&SPR=OFW2K)
    I installed the example on our Web Server (NTServer + IIS 4.0).
    When I open a page with OWC (client-side VB script)
    on a PC ( windows 2000, with Office 2000 and OWC installed )
    I get an error "error in DLL".
    When I open the same page with OWC (client-side VB script)
    on a PC ( windows 95, withOUT Office 2000 and OWC installed )
    I get an error "ActiveX control can't create object".

    Can someone help me?

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office Web Components (OWC)

    read on to this one - link was at the end of your KB page. It mentions can't create object error and says it's related to security setting.
    http://support.microsoft.com/support/kb/ar...s/Q195/8/26.ASP


    PS - you really only need the part of the url up to ".asp?"

  3. #3
    New Lounger
    Join Date
    May 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office Web Components (OWC)

    Hi,
    Thank you for your note.
    I have read that and have changed that.
    The mentioned error is after the InternetOption/security's
    changing.
    Did you try this example and did it really work?
    Thank you a lot.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    Cincinnati, Ohio, USA
    Posts
    7,089
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office Web Components (OWC)

    This sounds almost like an ASP page that is coded and expects to find a value that is not there. I would wonder what kind of data you are using in the pivot table - try making sure there are no null values.

    This can, but not always of course, be caused by dynamic data where the page's code is created on the fly by ASP or some other code.

    If you can send or post partial source of the page where it seems to fail, it may help.

    Remember that you are dealing with data, and that nearly everything in a dynamic page is an object - the data elements, the data source, the login to the sending app, etc.
    -Mark

  5. #5
    New Lounger
    Join Date
    May 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office Web Components (OWC)

    Thank you for your note.
    I have sent the address with the code I have tried.
    (http://support.microsoft.com/support.../Q258/1/87.ASP)
    If you download this, you can see all the code
    under PivotTable directory and in Data.htm .
    I suppose that the problem is the path.
    Data.htm :
    **********
    Const sDataPath = "D:dataowebcompdata"

    Function GetDBPath()

    Select Case UCASE( document.protocol)
    Case "FILE PROTOCOL": GetDBPath = "..data"
    Case "HYPERTEXT TRANSFER PROTOCOL": GetDBPath = sDataPath
    Case Else: GetDBPath = vbNullString
    End Select

    End Function

    When VBScript runs on Client Side what happens with
    GetDBPath() ?

    The Pivot examples work on Server , but don't work
    on Client machine (with or without Office 2000).

  6. #6
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Office Web Components (OWC)

    is the data at that path on the client machine? if it's on a shared drive use a UNC.

    does the pivot table applet load at all?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •