Re: CDOSYS Mail Problem: Win2003 Server?
From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/12/04
- Next message: Joe Celko: "Re: Insert blank row after a group of records."
- Previous message: Anith Sen: "Re: EXEC(sqlstatement) Resultset usage"
- In reply to: TomT: "Re: CDOSYS Mail Problem: Win2003 Server?"
- Next in thread: TomT: "Re: CDOSYS Mail Problem: Win2003 Server?"
- Reply: TomT: "Re: CDOSYS Mail Problem: Win2003 Server?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 12 Nov 2004 13:32:52 -0500
> 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
- Next message: Joe Celko: "Re: Insert blank row after a group of records."
- Previous message: Anith Sen: "Re: EXEC(sqlstatement) Resultset usage"
- In reply to: TomT: "Re: CDOSYS Mail Problem: Win2003 Server?"
- Next in thread: TomT: "Re: CDOSYS Mail Problem: Win2003 Server?"
- Reply: TomT: "Re: CDOSYS Mail Problem: Win2003 Server?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
