CDO.Message Problems in live environment...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David Conorozzo (DavidConorozzo_at_community.nospam)
Date: 10/29/04 

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?

Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Error during pre-login handshake: SSL certificates and IIS?!
    ... After rebooting the server, people were telling me that SQL wasn't working anymore. ... If I'd be installing a new certificate, manually, I think I would break up again the SQL... ... Scott wrote: ...
    (microsoft.public.sqlserver.server)