dbTalk Databases Forums  

Urgent: again, ActiveX component can't create object, for a Job

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Urgent: again, ActiveX component can't create object, for a Job in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mihaela M.
 
Posts: n/a

Default Urgent: again, ActiveX component can't create object, for a Job - 04-05-2004 , 09:57 AM






Hello again.
I've created a DTS, which creates an object , like this:
Set enobj=CreateObject("encrypt.encr")

I execute the DTS from Enterprise Manager, from the server, and it works.
Then, I set a schedule for the DTS, and a new job was generated for the DTS.
But when I try to execute the job, also from Enterprise Manager from the
server, it occurrs the following error:
ActiveX component can't create object: 'encrypt.encr'

Which is the problem? Because I execute from the server, and the object is
registered on the server.

Thanks!




Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: Urgent: again, ActiveX component can't create object, for a Job - 04-06-2004 , 12:55 PM






You may want to try registering the object on the server
when logged in under the service account that SQL Agent
uses.

-Sue

On Mon, 5 Apr 2004 17:57:31 +0300, "Mihaela M."
<mihaela.mesaros (AT) s-concept (DOT) net> wrote:

Quote:
Hello again.
I've created a DTS, which creates an object , like this:
Set enobj=CreateObject("encrypt.encr")

I execute the DTS from Enterprise Manager, from the server, and it works.
Then, I set a schedule for the DTS, and a new job was generated for the DTS.
But when I try to execute the job, also from Enterprise Manager from the
server, it occurrs the following error:
ActiveX component can't create object: 'encrypt.encr'

Which is the problem? Because I execute from the server, and the object is
registered on the server.

Thanks!




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.