system.runtime.interopservices.COMException

[Guest]

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.

 

[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.

 

[Armin Zingler]

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

 

[Guest]

Yes, you are right Armin.
Actually there is not Excel being installed. After I install, Excel it works
fine now.
Thanks.