Components won't laod after successful install

[Chris Redekop]

I have a web page which serves up a pivot table and a chart control, and it
works perfectly on all but 1 client machine. On this machine, for some
reason the components won't load on the web page, I've tried uninstalling
them and reinstalling them and the installation completes successfully, but
they still won't load. I've restarted IE, restarted the computer, it's not
an IE security issue, the controls simply aren't loading...is there any way
I can get some detailed information about why a control failed to load on a
page?...thx

 

[Kostya]

On which configuration it doesn't works (OS, IE version, OWC version)?
Which GUID are you using to create ChartSpace object?

 

[Chris Redekop]

It's Win2K Server (5.00.2195), IE 5.00.2920, OWC 10 (latest one from MS).
The GUID's I'm using:
DataSource: 0002E553-0000-0000-C000-000000000046
ChartSpace: 0002E556-0000-0000-C000-000000000046
PivotTable: 0002E552-0000-0000-C000-000000000046
I have other boxes that are this exact same configuration that work
fine....it's just this single box for some reason. I'm thinking this box
might just need a reinstall....

 

[Man Manovich]

I have Win98 + IE5.5 + the latest OWC from Microsoft (build 10.0.6619.0),
and I can't create ChartSpace object with official GUID
{0002E556-0000-0000-C000-000000000046}. But I can create it using
{0002E546-0000-0000-C000-000000000046}. I have reproduced it on few
computers and with this OWC build only. It looks like a bug. Try to install
not last version.

 

[Thao Moua [ms]]

Here's a matrix of the GUID and IE version and which GUID to use.

(latest OWC SP3) (old OWC pre-SP3)
(IE6x) use old/new GUID must use old GUID
(IE5x) use new GUID only must use old GUID

Old GUID for OWC10:
Spreadsheet 0002E551-0000-0000-C000-000000000046
PivotTable 0002E552-0000-0000-C000-000000000046
DataSourceControl 0002E553-0000-0000-C000-000000000046
Chart 0002E556-0000-0000-C000-000000000046

New GUID for OWC10
Spreadsheet 0002E541-0000-0000-C000-000000000046
Chart 0002E546-0000-0000-C000-000000000046
PivotTable 0002E542-0000-0000-C000-000000000046
DSC 0002E543-0000-0000-C000-000000000046

Chris, verify the other Win2k servers have the same config as you (ie same
IE version and OWC10 version.) What latest OWC10 version do you have?
----------------------------------------------------------------------
Thao Moua
OWC Chartspace Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
----------------------------------------------------------------------

 

[Man Manovich]

Can you specify which build number was last for pre-SP3 OWC so I can
dynamicaly choose right GUID?

 

[Claude Vernier]

Seems I have a problem similar to yours but, if I understood correctly, on
the server side only...

I have a Web application that displays pivot tables and charts linked to
olap cubes.
I'm using javascript to detect if user have OWC and, if not, I instantiate
the OWC on the server to render its HTML.

OWC10.PivotTable oPT = new OWC10.PivotTableClass();
oPT.XMLData = this.oCurrentXMLData.InnerText;

//Display the HTML table...
sInnerHTML += "<BR>" + oPT.HTMLData;

OWC10 is referenced to {0002E550-0000-0000-C000-000000000046}\1.1\0\tlbimp

The first line of code gives me: "COM object with CLSID
{0002E542-0000-0000-C000-000000000046} is either not valid or not registered."

This application is working on DEV (w2k) and TEST (w2k3 std) but not in
PROD (w2k3 std).

On each server, I installed OWC10 from:
"http://download.microsoft.com/download/OfficeXPStandard/owc10/1033/WIN98MeXP/EN-US/owc10.exe"

I can't see why the GUID wouldn't be good and how I could change it from the
server's code. If you could explain this ?

Also, I don't know a thing about this SP3... can you give me some pointers ?

Thanks you very much,
Claude Vernier

ps: My english can seem a little bit rude,
I'm sorry, it is not my primary language.

 

[Alvin Bruney [MVP]]

based on the grid provided, your application is not expected to work because
you are using the wrong guid. you should be using guid 2552 and not 2e542
for 2k3. Change the guid found in the object tag in the html file to the
appropriate guid and put it back on the w2k3 server. You will have to
constantly switch back and forth since changing the guid is not expected to
work on your development machine.

makes sense?

 

[Claude Vernier]

There's my problem, I do not think the problem is on the client...
As a test, I did try to change the GUIDs (both Pivot and Chart), either with
the old or new, it seems to work.

Let's me explain:
This page as two ways, if the user have the OWC on his machine I used it
but, if the he can't, I reload the page with a parameter in Querystring
(OWC=off), this way I can test then "NoOWC" feature on an "OWC-aware" machine.

So, if OWC = on,
it works with any GUIDs, at least on my DEV box.

if OWC = off, I use this code on the server-side, and an exception occurs:

OWC10.PivotTable oPT = new OWC10.PivotTableClass();
oPT.XMLData = this.oCurrentXMLData.InnerText;

//Display the HTML table...
sInnerHTML += "<BR>" + oPT.HTMLData;

This error occurs:
"COM object with CLSID {0002E542-0000-0000-C000-000000000046} is either not
valid or not registered."

Which I do not understand since I installed the same component on all the
servers I use.
I can't change this settings since it is the OWC that is referenced in my
ASP.Net project.

Unless, I reference both DLLs ( with the new GUIDs and with the old GUIDs )
into my project and I cast it differently in my code ?? In that case, what
DLLs should I use ??

Thanks again !
Claude

based on the grid provided, your application is not expected to work because
you are using the wrong guid. you should be using guid 2552 and not 2e542
for 2k3. Change the guid found in the object tag in the html file to the
appropriate guid and put it back on the w2k3 server. You will have to
constantly switch back and forth since changing the guid is not expected to
work on your development machine.

makes sense?

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Seems I have a problem similar to yours but, if I understood correctly, on
the server side only...

I have a Web application that displays pivot tables and charts linked to
olap cubes.
I'm using javascript to detect if user have OWC and, if not, I instantiate
the OWC on the server to render its HTML.

OWC10.PivotTable oPT = new OWC10.PivotTableClass();
oPT.XMLData = this.oCurrentXMLData.InnerText;

//Display the HTML table...
sInnerHTML += "<BR>" + oPT.HTMLData;

OWC10 is referenced to {0002E550-0000-0000-C000-000000000046}\1.1\0\tlbimp

The first line of code gives me: "COM object with CLSID
{0002E542-0000-0000-C000-000000000046} is either not valid or not
registered."

This application is working on DEV (w2k) and TEST (w2k3 std) but not in
PROD (w2k3 std).

On each server, I installed OWC10 from:
"http://download.microsoft.com/download/OfficeXPStandard/owc10/1033/WIN98MeXP/EN-US/owc10.exe"

I can't see why the GUID wouldn't be good and how I could change it from
the
server's code. If you could explain this ?

Also, I don't know a thing about this SP3... can you give me some pointers
?

Thanks you very much,
Claude Vernier

ps: My english can seem a little bit rude,
I'm sorry, it is not my primary language.

 

[Alvin Bruney [MVP]]

To figure this out, what you need to do is open up visual studio and drop a
pivot table onto a web form. open up the html view and note the clsid. If it
is not 2e542, your application will not work on the server. You may have to
look at the documentation available for owc to figure out which owc dll
2e542 belongs to, then register this assembly on the server.

For my system, doing the same method, owc 10 sp2 and owc11 do not contain
the 2e542.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

There's my problem, I do not think the problem is on the client...
As a test, I did try to change the GUIDs (both Pivot and Chart), either
with
the old or new, it seems to work.

Let's me explain:
This page as two ways, if the user have the OWC on his machine I used it
but, if the he can't, I reload the page with a parameter in Querystring
(OWC=off), this way I can test then "NoOWC" feature on an "OWC-aware"
machine.

So, if OWC = on,
it works with any GUIDs, at least on my DEV box.

if OWC = off, I use this code on the server-side, and an exception occurs:

OWC10.PivotTable oPT = new OWC10.PivotTableClass();
oPT.XMLData = this.oCurrentXMLData.InnerText;

//Display the HTML table...
sInnerHTML += "<BR>" + oPT.HTMLData;

This error occurs:
"COM object with CLSID {0002E542-0000-0000-C000-000000000046} is either
not
valid or not registered."

Which I do not understand since I installed the same component on all the
servers I use.
I can't change this settings since it is the OWC that is referenced in my
ASP.Net project.

Unless, I reference both DLLs ( with the new GUIDs and with the old
GUIDs )
into my project and I cast it differently in my code ?? In that case, what
DLLs should I use ??

Thanks again !
Claude

based on the grid provided, your application is not expected to work
because
you are using the wrong guid. you should be using guid 2552 and not 2e542
for 2k3. Change the guid found in the object tag in the html file to the
appropriate guid and put it back on the w2k3 server. You will have to
constantly switch back and forth since changing the guid is not expected
to
work on your development machine.

makes sense?

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
message

Seems I have a problem similar to yours but, if I understood correctly,
on
the server side only...

I have a Web application that displays pivot tables and charts linked
to
olap cubes.
I'm using javascript to detect if user have OWC and, if not, I
instantiate
the OWC on the server to render its HTML.

OWC10.PivotTable oPT = new OWC10.PivotTableClass();
oPT.XMLData = this.oCurrentXMLData.InnerText;

//Display the HTML table...
sInnerHTML += "<BR>" + oPT.HTMLData;

OWC10 is referenced to
{0002E550-0000-0000-C000-000000000046}\1.1\0\tlbimp

The first line of code gives me: "COM object with CLSID
{0002E542-0000-0000-C000-000000000046} is either not valid or not
registered."

This application is working on DEV (w2k) and TEST (w2k3 std) but not
in
PROD (w2k3 std).

On each server, I installed OWC10 from:
"http://download.microsoft.com/download/OfficeXPStandard/owc10/1033/WIN98MeXP/EN-US/owc10.exe"

I can't see why the GUID wouldn't be good and how I could change it
from
the
server's code. If you could explain this ?

Also, I don't know a thing about this SP3... can you give me some
pointers
?

Thanks you very much,
Claude Vernier

ps: My english can seem a little bit rude,
I'm sorry, it is not my primary language.



:

Here's a matrix of the GUID and IE version and which GUID to use.

(latest OWC SP3) (old OWC pre-SP3)
(IE6x) use old/new GUID must use old GUID
(IE5x) use new GUID only must use old GUID

Old GUID for OWC10:
Spreadsheet 0002E551-0000-0000-C000-000000000046
PivotTable 0002E552-0000-0000-C000-000000000046
DataSourceControl 0002E553-0000-0000-C000-000000000046
Chart 0002E556-0000-0000-C000-000000000046

New GUID for OWC10
Spreadsheet 0002E541-0000-0000-C000-000000000046
Chart 0002E546-0000-0000-C000-000000000046
PivotTable 0002E542-0000-0000-C000-000000000046
DSC 0002E543-0000-0000-C000-000000000046

Chris, verify the other Win2k servers have the same config as you (ie
same
IE version and OWC10 version.) What latest OWC10 version do you have?
----------------------------------------------------------------------
Thao Moua
OWC Chartspace Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
----------------------------------------------------------------------

:

I have Win98 + IE5.5 + the latest OWC from Microsoft (build
10.0.6619.0),
and I can't create ChartSpace object with official GUID
{0002E556-0000-0000-C000-000000000046}. But I can create it using
{0002E546-0000-0000-C000-000000000046}. I have reproduced it on few
computers and with this OWC build only. It looks like a bug. Try to
install
not last version.

It's Win2K Server (5.00.2195), IE 5.00.2920, OWC 10 (latest one
from
MS).
The GUID's I'm using:
DataSource: 0002E553-0000-0000-C000-000000000046
ChartSpace: 0002E556-0000-0000-C000-000000000046
PivotTable: 0002E552-0000-0000-C000-000000000046
I have other boxes that are this exact same configuration that
work
fine....it's just this single box for some reason. I'm thinking
this
box
might just need a reinstall....