Re: CDOSYS Mail Problem: Win2003 Server?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: TomT (tomt_at_tomt.com)
Date: 11/12/04 

Date: Fri, 12 Nov 2004 10:58:01 -0800

I got mixed up with xp_sendmail with that last message, xp_smtp_sendmail is
just fine, thanks.

The other code (using cdo) was cribbed off a web site quite some time ago.
I'm glad to be done with it, to be honest. At the time, it appeared the only
solution.

Thanks for all your help, and I think I'll skip the "investigation into the
possible values for SendUsing", at least for now...

Thanks

"Aaron [SQL Server MVP]" wrote:

> > I'm still curious, however, why the previous method fails under Windows
> > Server 2003.
>
> SET @cdoSendUsingPort = 25
>
> This is the property "send using port" meaning "use a port, rather than the
> pickup folder", not to be confused with the property "smtpserverport"
> meaning "use THIS port."
>
> Using xp_smtp_sendmail, you don't have 80 lines of configuration code to
> confuse you, and you also don't go about populating the different properties
> in different ways (why do you use a variable for cdoSendUsingPort but not
> for smtpServerPort???).
>
> I would tell you how to fix it, but since I feel very strongly that you
> should *NOT* be using CDO here, I will leave the investigation into the
> possible values for SendUsing as an exercise for the reader.
>
> > I do need the @from functionality, as this process is used to send out
> order
> > confirmations, and other mail to customers which needs to be from
> different
> > departments.
>
> And just like CDO, xp_smtp_sendmail provides this functionality, so I'm not
> sure what the fuss is about.
>
> A
>
>
>

Relevant Pages

  • Re: SMTP of which WEB Site
    ... I suggest that you adjust whatever code instantiates the COM object, ... > CDO object including some properties about the web site of the IIS. ...
    (microsoft.public.inetserver.iis)
  • Re: CDO.Message.1 error 80040213
    ... I was referring to the "smarthost" vbscript variable (yes, ... says that when sending mail via a locally installed SMTP-server, ... "sendusing" should be set to "2". ... I've played around with my sendmail.asp on a server where CDO works, ...
    (microsoft.public.inetserver.iis.smtp_nntp)
  • Re: SMTP of which WEB Site
    ... You caught my typo for the IIS. ... If the CDO does not know ... > c) I suggest that you adjust whatever code instantiates the COM object, ... >>CDO object including some properties about the web site of the IIS. ...
    (microsoft.public.inetserver.iis)