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

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?
dwierAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jkrConnect With a Mentor Commented:
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
 
dwierAuthor Commented:
Adding more components to Installation package was the fix (via this link: http://www.ureader.com/message/594379.aspx)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.