Solved

Retrieving the COM class factory for component with CLSID {...} failed due to the following error: 80040154.

Posted on 2007-11-16
2
5,868 Views
Last Modified: 2012-06-27
I am building a Windows Service with a Filewatcher which will move some files to different locations when dropped in a particular folder. Then, using the Microsoft DTS Object Library, it runs a DTS package on a network SQL Server (2000).
I can get this to run fine on my computer, which HAS SQL Tools on it.
BUT - I can NOT get it to fire the DTS package without the error in the title, if it's on another server. The other server DOES NOT Have any SQL tools or databases on it.
The Interop package was successfully created in VS.net 2005, and the installer successfully installs both the Interop version and the orginal dtspkg.dll, along with the DTS.dll.

The full error is:
Retrieving the COM class factory for component with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154.

I guess the first and main question is  - How can I fix this?
the second one is to ask: To be able to use this on another server, will SQL Server tools need to be installed, to make it work?
0
Comment
Question by:dwier
2 Comments
 
LVL 86

Accepted Solution

by:
jkr earned 500 total points
Comment Utility
Well, the error code is

//
// MessageId: REGDB_E_CLASSNOTREG
//
// MessageText:
//
//  Class not registered
//
#define REGDB_E_CLASSNOTREG              _HRESULT_TYPEDEF_(0x80040154L)

Maybe http://www.ureader.com/message/594379.aspx or http://support.microsoft.com/kb/326909 can help.
0
 

Author Closing Comment

by:dwier
Comment Utility
Adding more components to Installation package was the fix (via this link: http://www.ureader.com/message/594379.aspx)
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now