CDO.Message Problems in live environment...
From: David Conorozzo (DavidConorozzo_at_community.nospam)
Date: 10/29/04
- Next message: Aaron [SQL Server MVP]: "Re: CDO.Message Problems in live environment..."
- Previous message: WTH: "Re: Stoopid noobilicious question: Is there a way to have SQL Server return data as XML..."
- Next in thread: Aaron [SQL Server MVP]: "Re: CDO.Message Problems in live environment..."
- Reply: Aaron [SQL Server MVP]: "Re: CDO.Message Problems in live environment..."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 29 Oct 2004 12:30:02 -0700
I want to send an e-mail message with attachments from a job in SQL Server.
I chose not to use xp_sendmail b/c I don't have outlook (or any MAPI client)
on the production server and I don't want to put it on there. Also, my
production server does not have an SMTP server but can contact one.
I created a stored procedure that uses CDOSYS to create a message, attach a
file and send the message through an external SMTP server. When I tested
this on my test server, it works fine. When I move it to my production
server, it does not work.
Test Server: Win2K3 SQL Ent. w/IIS and SMTP (but also did tests using
external SMTP server address)
Production Server: Win2K3 SQL Ent., both Windows and SQL are clustered.
I also created a VB Script on the production server that used the same code
and the same SMTP server as the SQL Script and it works fine. I also tested
the SQL script without the attachment and it still did not work and gave the
same error which in decimal is -2147220960 and in Hex is 80040220. The error
means (according to some sites): The "SendUsing" configuration value is
invalid
It is not though. I specify 2 for that value which means non-local and like
I said, this exact code works in VB Script on the production system and in
SQL on the test system. Maybe this is some kind of permissions problem?
- Next message: Aaron [SQL Server MVP]: "Re: CDO.Message Problems in live environment..."
- Previous message: WTH: "Re: Stoopid noobilicious question: Is there a way to have SQL Server return data as XML..."
- Next in thread: Aaron [SQL Server MVP]: "Re: CDO.Message Problems in live environment..."
- Reply: Aaron [SQL Server MVP]: "Re: CDO.Message Problems in live environment..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
