Re: Microsoft VBScript runtime error
From: Calvin (Calvin_at_discussions.microsoft.com)
Date: 11/02/04
- Next message: Ray Costanzo [MVP]: "Re: Microsoft VBScript runtime error"
- Previous message: Murphy: "Re: OU name to variable"
- In reply to: Ray Costanzo [MVP]: "Re: Microsoft VBScript runtime error"
- Next in thread: Ray Costanzo [MVP]: "Re: Microsoft VBScript runtime error"
- Reply: Ray Costanzo [MVP]: "Re: Microsoft VBScript runtime error"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 2 Nov 2004 00:48:02 -0800
1. Had registered the dll file, but It's still failed to work.
2. Sorry, I use CDO on W2k3 server instead of CDONTS
3. I don't want to create user profile, and install a outlook client to
support MAPI application. My objective is just want to use a simple way to
trigger a email alert to SQL administrator when the scheduled job failed.
"Ray Costanzo [MVP]" wrote:
> 1. Try reregistering CDONTS.dll (At the command prompt [cmd.exe], enter:
> regsvr32 %windir%\system32\cdonts.dll
> )
>
> 2. This shouldn't be expected to work on a W2K3 server, unless you have
> manually copied a CDONTS.dll file from an NT or 2000 machine and registered
> it.
>
> 3. The SQL Agent is capable of sending e-mail alerts on job failures by
> design in SQL Server. Any particular reason you're not using that
> functionality?
>
> Ray at home
>
>
>
> "Calvin" <Calvin@discussions.microsoft.com> wrote in message
> news:790046DB-1FA3-4CAE-9086-FB979408DCD1@microsoft.com...
> > Hi,
> > The error message windows prompted
> > "Error: ActiveX component can't create object: 'CDONTS.NewMail';
> > Code: 800A01AD;
> > Source: Ms VBScript runtime error"
> > when I run the script below on certain windows NT servers with IIS and
> > SMTP
> > services running.
> > -------------------------------------------------------------
> > Set objNewMail = CreateObject("CDONTS.NewMail")
> > objNewMail.From = "xxxx@xxxx.com"
> > objNewMail.To = "xxxx@xxxx.com"
> > objNewMail.Subject = "subject"
> > objNewMail.Body = "testing ..."
> > Set objNewMail = Nothing
> > -------------------------------------------------------------
> > Some other NT/W2K/W2k3 servers have no problem to run this script at all !
> > Any experts can advise what is the actual cause ? I need to use the script
> > to
> > send email alert when backup job failed on SQL server. Thanks.
>
>
>
- Next message: Ray Costanzo [MVP]: "Re: Microsoft VBScript runtime error"
- Previous message: Murphy: "Re: OU name to variable"
- In reply to: Ray Costanzo [MVP]: "Re: Microsoft VBScript runtime error"
- Next in thread: Ray Costanzo [MVP]: "Re: Microsoft VBScript runtime error"
- Reply: Ray Costanzo [MVP]: "Re: Microsoft VBScript runtime error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
