Home All Groups Group Topic Archive Search About

system.runtime.interopservices.COMException

Author
21 Feb 2006 2:10 AM
Seok Bee
Dear Experts,

I've written a console program using Visual Studio 2005 (vb.net) and created
an executable file. In this program, I have added the Microsoft Excel 10.0
Object Library from the 'Add Reference'. From there, I copied all the dlls
and executable files created to the server with Window 2k Sp4 platform.

The problem is when I execute the file, I got the following error message:
-------------------------------
An unhandled exception of type 'system.runtime.interopservices.COMException'
occured in <executable filename>

addition information: Retrieving the COM class factory for component with
CLSID  {00024500-0000-0000-C000-000000000046} failed due to the following
error: 80040154.
----------------------------------

I checked from the Application log in the Event viewer got the following
error message:
-------------------------------------
Event Type:    Error
Event Source:    .NET Runtime 2.0 Error Reporting
Event Category:    None
Event ID:    5000
Date:        21-Feb-06
Time:        9:44:22 AM
User:        N/A
Computer:    TEKLANG2
Description:
EventType clr20r3, P1 spqautomation.exe, P2 1.0.0.0, P3 43fa6ecf, P4
spqautomation, P5 1.0.0.0, P6 43fa6ecf, P7 19, P8 1, P9
pszqoadhx1u5zahbhohghldgiy4qixhx, P10 NIL.
Data:
0000: 63 00 6c 00 72 00 32 00   c.l.r.2.
0008: 30 00 72 00 33 00 2c 00   0.r.3.,.
0010: 20 00 73 00 70 00 71 00    .s.p.q.
0018: 61 00 75 00 74 00 6f 00   a.u.t.o.
0020: 6d 00 61 00 74 00 69 00   m.a.t.i.
0028: 6f 00 6e 00 2e 00 65 00   o.n...e.
0030: 78 00 65 00 2c 00 20 00   x.e.,. .
0038: 31 00 2e 00 30 00 2e 00   1...0...
0040: 30 00 2e 00 30 00 2c 00   0...0.,.
0048: 20 00 34 00 33 00 66 00    .4.3.f.
0050: 61 00 36 00 65 00 63 00   a.6.e.c.
0058: 66 00 2c 00 20 00 73 00   f.,. .s.
0060: 70 00 71 00 61 00 75 00   p.q.a.u.
0068: 74 00 6f 00 6d 00 61 00   t.o.m.a.
0070: 74 00 69 00 6f 00 6e 00   t.i.o.n.
0078: 2c 00 20 00 31 00 2e 00   ,. .1...
0080: 30 00 2e 00 30 00 2e 00   0...0...
0088: 30 00 2c 00 20 00 34 00   0.,. .4.
0090: 33 00 66 00 61 00 36 00   3.f.a.6.
0098: 65 00 63 00 66 00 2c 00   e.c.f.,.
00a0: 20 00 31 00 39 00 2c 00    .1.9.,.
00a8: 20 00 31 00 2c 00 20 00    .1.,. .
00b0: 70 00 73 00 7a 00 71 00   p.s.z.q.
00b8: 6f 00 61 00 64 00 68 00   o.a.d.h.
00c0: 78 00 31 00 75 00 35 00   x.1.u.5.
00c8: 7a 00 61 00 68 00 62 00   z.a.h.b.
00d0: 68 00 6f 00 68 00 67 00   h.o.h.g.
00d8: 68 00 6c 00 64 00 67 00   h.l.d.g.
00e0: 69 00 79 00 34 00 71 00   i.y.4.q.
00e8: 69 00 78 00 68 00 78 00   i.x.h.x.
00f0: 20 00 4e 00 49 00 4c 00    .N.I.L.
00f8: 0d 00 0a 00               ....   
---------------------------------------------------

May I know, how could I possible solve this error and get my executable file
running?

Many thanks in advance.

Author
21 Feb 2006 2:49 AM
vbnetdev
Check your references and make sure no yellow exclamation points are by
them. If there are, remove and readd them.

Somehow someway a class is not registered that you are using. You need to
find it and regsrv it.

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com



Show quoteHide quote
"Seok Bee" <seok***@yahoo.com> wrote in message
news:FD2814A7-645C-43D6-8D15-26678F6180AE@microsoft.com...
> Dear Experts,
>
> I've written a console program using Visual Studio 2005 (vb.net) and
> created
> an executable file. In this program, I have added the Microsoft Excel 10.0
> Object Library from the 'Add Reference'. From there, I copied all the dlls
> and executable files created to the server with Window 2k Sp4 platform.
>
> The problem is when I execute the file, I got the following error message:
> -------------------------------
> An unhandled exception of type
> 'system.runtime.interopservices.COMException'
> occured in <executable filename>
>
> addition information: Retrieving the COM class factory for component with
> CLSID  {00024500-0000-0000-C000-000000000046} failed due to the following
> error: 80040154.
> ----------------------------------
>
> I checked from the Application log in the Event viewer got the following
> error message:
> -------------------------------------
> Event Type: Error
> Event Source: .NET Runtime 2.0 Error Reporting
> Event Category: None
> Event ID: 5000
> Date: 21-Feb-06
> Time: 9:44:22 AM
> User: N/A
> Computer: TEKLANG2
> Description:
> EventType clr20r3, P1 spqautomation.exe, P2 1.0.0.0, P3 43fa6ecf, P4
> spqautomation, P5 1.0.0.0, P6 43fa6ecf, P7 19, P8 1, P9
> pszqoadhx1u5zahbhohghldgiy4qixhx, P10 NIL.
> Data:
> 0000: 63 00 6c 00 72 00 32 00   c.l.r.2.
> 0008: 30 00 72 00 33 00 2c 00   0.r.3.,.
> 0010: 20 00 73 00 70 00 71 00    .s.p.q.
> 0018: 61 00 75 00 74 00 6f 00   a.u.t.o.
> 0020: 6d 00 61 00 74 00 69 00   m.a.t.i.
> 0028: 6f 00 6e 00 2e 00 65 00   o.n...e.
> 0030: 78 00 65 00 2c 00 20 00   x.e.,. .
> 0038: 31 00 2e 00 30 00 2e 00   1...0...
> 0040: 30 00 2e 00 30 00 2c 00   0...0.,.
> 0048: 20 00 34 00 33 00 66 00    .4.3.f.
> 0050: 61 00 36 00 65 00 63 00   a.6.e.c.
> 0058: 66 00 2c 00 20 00 73 00   f.,. .s.
> 0060: 70 00 71 00 61 00 75 00   p.q.a.u.
> 0068: 74 00 6f 00 6d 00 61 00   t.o.m.a.
> 0070: 74 00 69 00 6f 00 6e 00   t.i.o.n.
> 0078: 2c 00 20 00 31 00 2e 00   ,. .1...
> 0080: 30 00 2e 00 30 00 2e 00   0...0...
> 0088: 30 00 2c 00 20 00 34 00   0.,. .4.
> 0090: 33 00 66 00 61 00 36 00   3.f.a.6.
> 0098: 65 00 63 00 66 00 2c 00   e.c.f.,.
> 00a0: 20 00 31 00 39 00 2c 00    .1.9.,.
> 00a8: 20 00 31 00 2c 00 20 00    .1.,. .
> 00b0: 70 00 73 00 7a 00 71 00   p.s.z.q.
> 00b8: 6f 00 61 00 64 00 68 00   o.a.d.h.
> 00c0: 78 00 31 00 75 00 35 00   x.1.u.5.
> 00c8: 7a 00 61 00 68 00 62 00   z.a.h.b.
> 00d0: 68 00 6f 00 68 00 67 00   h.o.h.g.
> 00d8: 68 00 6c 00 64 00 67 00   h.l.d.g.
> 00e0: 69 00 79 00 34 00 71 00   i.y.4.q.
> 00e8: 69 00 78 00 68 00 78 00   i.x.h.x.
> 00f0: 20 00 4e 00 49 00 4c 00    .N.I.L.
> 00f8: 0d 00 0a 00               ....
> ---------------------------------------------------
>
> May I know, how could I possible solve this error and get my executable
> file
> running?
>
> Many thanks in advance.
Author
21 Feb 2006 9:33 AM
Armin Zingler
"Seok Bee" <seok***@yahoo.com> schrieb
> Dear Experts,
>
> I've written a console program using Visual Studio 2005 (vb.net) and
> created an executable file. In this program, I have added the
> Microsoft Excel 10.0 Object Library from the 'Add Reference'. From
> there, I copied all the dlls and executable files created to the
> server with Window 2k Sp4 platform.


Is Excel installed there? I ask because some people think they access Excel
without installing them. The Interop layer is only a layer between the own
app and the COM application. Without the COM application, it still doesn't
run. You probably know this already (but maybe not).



Armin
Author
21 Feb 2006 9:46 AM
Seok Bee
Yes, you are right Armin.
Actually there is not Excel being installed. After I install, Excel it works
fine now.
Thanks.

Show quoteHide quote
"Armin Zingler" wrote:

> "Seok Bee" <seok***@yahoo.com> schrieb
> > Dear Experts,
> >
> > I've written a console program using Visual Studio 2005 (vb.net) and
> > created an executable file. In this program, I have added the
> > Microsoft Excel 10.0 Object Library from the 'Add Reference'. From
> > there, I copied all the dlls and executable files created to the
> > server with Window 2k Sp4 platform.
>
>
> Is Excel installed there? I ask because some people think they access Excel
> without installing them. The Interop layer is only a layer between the own
> app and the COM application. Without the COM application, it still doesn't
> run. You probably know this already (but maybe not).
>
>
>
> Armin
>
>