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

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  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/

• Lowell

  SSC Guru

  Points: 323524

  More actions

  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!