Attachment using extendet store procedures

I am trying to send SMTP email with attachment using cdosysmail and getting
error on this line:
EXEC @.hr = sp_OAMethod @.MailID, 'AddAttachment', NULL, @.FileSource
Error message:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded.
this store procedure is working on SQL 2000.
any help please.Perhaps @.FileSource is not a valid path/file name or the SQL Server process
does not have permissions to that resource.
"viktor" <serguienkov@.hotmail.com> wrote in message news:O4uh44XOGHA.3732@.TK
2MSFTNGP10.phx.gbl...
I am trying to send SMTP email with attachment using cdosysmail and getting
error on this line:
EXEC @.hr = sp_OAMethod @.MailID, 'AddAttachment', NULL, @.FileSource
Error message:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should
be discarded.
this store procedure is working on SQL 2000.
any help please.|||the same procedure work fine on SQL 2000 permission is not the case
"JT" <someone@.microsoft.com> wrote in message
news:OayLaIYOGHA.1676@.TK2MSFTNGP09.phx.gbl...
Perhaps @.FileSource is not a valid path/file name or the SQL Server process
does not have permissions to that resource.
"viktor" <serguienkov@.hotmail.com> wrote in message
news:O4uh44XOGHA.3732@.TK2MSFTNGP10.phx.gbl...
I am trying to send SMTP email with attachment using cdosysmail and
getting error on this line:
EXEC @.hr = sp_OAMethod @.MailID, 'AddAttachment', NULL, @.FileSource
Error message:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any,
should be discarded.
this store procedure is working on SQL 2000.
any help please.