467,921 Members | 1,287 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,921 developers. It's quick & easy.

xp_sendmail failed with mail error 0x80004005

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
  • viewed: 23312
Share:
2 Replies
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
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.

Similar topics

reply views Thread by Jeff Cochran | last post: by
6 posts views Thread by Rolf Kemper | last post: by
reply views Thread by Jeff Reed | last post: by
5 posts views Thread by Nathan Sokalski | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.