system.runtime.interopservices.COMException

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Seok Bee said:
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.
Click to expand...


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
 
Yes, you are right Armin.
Actually there is not Excel being installed. After I install, Excel it works
fine now.
Thanks.
 
Back
Top