By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,918 Members | 1,816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,918 IT Pros & Developers. It's quick & easy.

xp_sendmail failed with mail error 0x80004005

P: n/a
Hello!

My environment is: Win 2000 Server, MS SQL-Server 2000 (SP2)
and MS ExchangeServer 5.5

the two following TransactSQL-codepieces show different
results:

1. with attachment

master..xp_sendmail
@recipients = 'j*******@rac.de',
@subject = 'test',
@message = 'test',
-- ******************************
@attachments = 'c:\test.txt',
-- ******************************
@no_output = 'False'

-->18025 level 16 state 1 line 0
xp_sendmail failed with mail error 0x80004005

2. without attachment

master..xp_sendmail
@recipients = 'j*******@rac.de',
@subject = 'test',
@message = 'test',
-- ******************************
-- @attachments = 'c:\test.txt',
-- ******************************
@no_output = 'False'

-->Mail sent.

why am I not able to send emails with attachments?

Who can help me???

Thanks in advance

Jürgen
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hello,

I had faced similar problems. I think if u look into the site it will
help you definitely. I will try later and come up with a direct
solution. For time being try the site and find out if it helped.

http://www.sqldev.net/xp/xpsmtp.htm

Cheers
RVG

j.******@rac.de (Jürgen Hetzel) wrote in message news:<ef**************************@posting.google. com>...
Hello!

My environment is: Win 2000 Server, MS SQL-Server 2000 (SP2)
and MS ExchangeServer 5.5

the two following TransactSQL-codepieces show different
results:

1. with attachment

master..xp_sendmail
@recipients = 'j.******@rac.de',
@subject = 'test',
@message = 'test',
-- ******************************
@attachments = 'c:\test.txt',
-- ******************************
@no_output = 'False'

-->18025 level 16 state 1 line 0
xp_sendmail failed with mail error 0x80004005

2. without attachment

master..xp_sendmail
@recipients = 'j.******@rac.de',
@subject = 'test',
@message = 'test',
-- ******************************
-- @attachments = 'c:\test.txt',
-- ******************************
@no_output = 'False'

-->Mail sent.

why am I not able to send emails with attachments?

Who can help me???

Thanks in advance

Jürgen

Jul 20 '05 #2

P: n/a
I finally replaced xp_sendmail calls after repeated attempts with
"help" from MS and MANY MANY other tech support forums and BBS forms.
I even formatted the drives, reloading OS, SQL, Outlook.
It just plain doesnt work.
Dont beleive the "works fine for me" guys.
It doesnt.

USE xp_OACreate to access the IIS SMTP service you will now have to
install.. This service is MUCH faster and more secure than MAPI.

xp_sendmail is MAPI
Mapi is Outlook
Awake people dont put outlook on ......anything much less a server.
Change your code to use a STANDARD MS service.
Outlook is not a standard service, but a user app.

have a nice mapi-free day

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.