August 21, 2003 at 3:59 pm
I hope someone might be able to help me with this. I have a stored procedure which sends SMTP mail, and works fine on a number of servers.
However, on one (important) test system, it fails with the following message:
Error Occurred Calling Object: CDO.Message.1 The "SendUsing" configuration value is invalid.
The procedure is identical to the ones that run successfully on other systems.
Here is the portion that generates the error:
EXEC @Hresult = sp_OAMethod @iMsg, 'Send'
IF @Hresult <> 0
BEGIN
EXEC sp_OAGetErrorInfo @iMsg, @ErrorSource OUT, @ErrorDesc OUT
PRINT 'Error Occurred Calling Object: ' + @ErrorSource + ' ' + @ErrorDesc
RETURN
END
The error number is -2147220960, if that is of any help.
All the steps prior to the one above work without error.
I appreciate any help or suggestions....
August 22, 2003 at 8:20 am
Sounds like the email account is not set up correctly on that machine. Can you log in as the network user used by SQL agent and send a message via outlook?
Guarddata-
August 25, 2003 at 9:58 pm
Thanks very much for your reply. I had to reboot that system for some updates, and after that, it worked fine.
One of life's mysteries, I guess....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply