Office Web Components (OWC)

Topic

New Reply

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/kb/articles/Q258/1/87.ASP?LN=EN-US&SD=msdn&FR=0&qry=PivotTable&rnk=7&src=DHCS_MSPSS_msdn_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?

Reply | Quote

Replies

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%5B/url%5D

PS – you really only need the part of the url up to “.asp?”

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

Thank you for your note.
I have sent the address with the code I have tried.
(http://support.microsoft.com/support/kb/articles/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).

Reply | Quote

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?

Reply | Quote