dwier
asked on
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-0
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?
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-0
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER