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:
(1 row(s) affected)
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/cdo/co.../sendusing
Does anyone have any experience with this error?
Thanks for your help.