xp_sendmail failed with mail error 0x80004005

Jürgen Hetzel

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

Rajesh Garg

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

user extraordinaire

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