March 15, 2004 at 6:29 am
Due to company changes I've got to change from using Exchange to Novell groupwise for my mail client.
All of the test xp_sendmail procedures work to test mail configuration i.e.
exec master..xp_test_mapi_profile <profilename>
exec master..xp_get_mapi_default_profile
exec master..xp_get_mapi_profiles
exec master..xp_startmail, and I can start a session from Enterprise manager -> SQLmail
Yet when I try to send a mail using xp_sendmail I get the error : - Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80004005
Has any one any ideas on how to resolve this I've got till 16:30 GMT tomorrow (it's now 13:30). I like advance notice of change - don't you?
Thanks in advance
Stuart
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 15, 2004 at 11:59 pm
Stuart,
I do not believe it's possible - see INF: Frequently Asked Questions - SQL Server - SQL Mail for details. We've had the same issue on the client site and gave up on SQL Mail altogether. Instead, we used CDO mail as documented in HOW TO: Send E-Mail Without Using SQL Mail in SQL Server.
Also, check http://www.sqlservercentral.com/columnists/ckempster/sendingalertsviaacustomsmtpprocedure_printversion.asp - may be it'll also help.
Forgot to add: some alert functionality is lost when not using SQL Mail, unfortunately.
Cheers
--
George
March 16, 2004 at 9:35 am
There is a good article at http://www.sqldev.net/xp/xpsmtp.htm on using an extended stored procedure to replace SQLMail. This site includes the dll, and examples on using it. This solution also allows attachments to the mail.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply