Post reply

VBScript: ActiveX Component can't create Object CDONTS.NewMail Code: 800A01AD VBScript

  • April 2, 2012 at 11:20 am

    #100018

    I configured Database Mail on a new server and it goes in the queue but it does not send the message.

    I have tried all of the troubleshooting steps but no luck.

    So then I tried sending CDONTS EMail on a Server from SQL Server 2008 R2 x64 on a Server running Windows Server 2008 R2 x64 and I get command successfully completed but I do not receive an email.

    I do not believe that either problem is with SQL Server and I suspect it may be Windows related.

    I'm trying to isolate the problem so I ran the following VBScript:

    Set objMail = CreateObject("CDONTS.Newmail")

    objMail.From = "username@mydomain.com"

    objMail.To = "username@mydomain.com"

    objMail.Subject = "Test"

    objMail.Body = "Testing"

    objMail.Send

    Set objMail = Nothing

    I get the following error:

    ActiveX Component can't create Object CDONTS.NewMail Code: 800A01AD VBScript

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • April 2, 2012 at 11:42 am

    #1467771

    CDONTs was a com object, and that error says it's not registered yet;

    you may need to copy the dll to the server, and then register it.

    http://www.jppinto.com/2009/03/install-cdonts-mail-component-and-smtp-on-windows-server-2008/

    I know from your outer posts you had trouble getting regular db mail to work, but i would troubleshoot that before I'd use CDONTS.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply