May 7, 2007 at 4:01 pm
RE: SQL Server 2000 – Enterprise Edition – SP4
I have an application that is utilizing cdosysmail to send email from SPs and DTS packages. It was working fine until the end of January but now they are no longer receiving the emails. Of course the logical question is what has changed. But, I am new here and cannot answer that.
Cdosysmail is working fine on other servers and I cannot find any differences between them and this server.
I have manually called sp_send_cdosysmail from query analyzer but am receiving the following error:
-----------
-2147220960
(1 row(s) affected)
Source: CDO.Message.1
Description: The "SendUsing" configuration value is invalid.
I searched the cdosysmail proc and the only command that sets the "SendUsing" property is the same on all my servers with the value of 2:
EXEC @hr = sp_OASetProperty @iMsg, Configuration.fields("http://schemas.microsoft.com/c...onfiguration/sendusing").Value','2'
Does anyone have any experience with this error?
Thanks for your help.
May 9, 2007 at 1:35 pm
A lot of variables involved with sending SMTP mail. First if they implemented the SP-Send_cdosysmail exactly as published on the Microsoft site (http://support.microsoft.com/kb/312839) then run the following:
select * from dbo.cdosysmail_failures
and see if the output provides any additional clues (though probably it will just repeat what you are already seeing).
Additionally check the SP for the following line:
EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpserver").Value', YourComputerNameOrIP
use the value of YourComputerNameOrIP you find and insure you can "PING" that server. If the value is the same as your SQL server then insure SMTP under IIS is configured correctly (you should be able to test using OutLook Express) and you can send email outside of SQL. This will help eliminate problems outside of SQL.
after that we will be getting into "permssion" issues with SQL talking to different components.
HTH,
James.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply