I've been working with CDONTS email messaging for quite a while on a Windows 2000 server that also had SQL 2000 installed on it. This server was our Intranet server so it had IIS on it too. I had a SQL stored procedure that sent the mail, and all worked perfectly.
Recently, we purchased 2 new servers to replace the old one. We decided to load Windows 2003 and put the SQL databases on one server (HMCNTDOCSQL) and the web services (IIS on a different server -- HMCNTDOC1). The SMTP service is running on HMCNTDOC1,a nd I set it up with the correct name of our SMTP server. As you can probably guess, it isn't working any more. I'm using the same SQL stored procedure, and no emails.
Yesterday, I edited this code into my web page (.asp):
MyBody="I Hope This Works"
When I use this, I get the following error message:
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object: 'CDONTS.NewMail'
/ITChangeNotification/IT/Insert.asp, line 57
I think the code is correct, so I'm wondering if there is something I missed in setting up IIS.