March 29, 2007 at 1:55 am
Good day All,
I am experiencing this error when trying to execute xp_sendmail:
Server: Msg 50000, Level 16, State 1, Procedure up_OARaiseError, Line 43
sp_OACreate SQLMail_G.clsBase failed: null object
Mail failed.
This occurs when even just running the extended sproc without any parameters. I know that this sproc calls odsole70.dll, but any other info is quite scarce.
Has anybody seen this before, and how do i get xp_sendmail to work properly?
Thanks for the help, have a great day.
March 29, 2007 at 5:01 am
It's kinda har to say (up_OARaiserror looks like something custom made) other than xp_sendmail is generally a royal PITA to get working. From when I used to use it, I can't recall the need of any sp_OA* procs.
Probably the 'easiest' (?) would be to get rid of xp_sendmail altogether - use xpsmtp instead.
http://www.sqldev.net/xp/xpsmtp.htm
It's easier, more reliable, and... just works. I recommend at least you take a look.
/Kenneth
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply