Sending SMTP email

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.

Hi

Have you seen the example at http://www.aspfaq.com/show.asp?id=2403
also check out the xp_smtp_sendmail alternative as this should be alot
easier to implement.

You should also look at calling sp_OAGetErrorInfo to get error details.

John

"viktor" wrote:

> I am trying to send SMTP email with attachment using cdosysmail and gettin
g
> 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, shoul
d
> be discarded.
>
> this store procedure is working on SQL 2000.
>
> any help please.
>
>
>

I am getting this  error description:
Output values of type Object are not allowed in result sets

"John Bell" < jbellnewsposts@hotma
il.com> wrote in message
news:23B0BAE4-FE53-4859-A6D6- 97E00453FC1F@microso
ft.com...
> Hi
>
> Have you seen the example at http://www.aspfaq.com/show.asp?id=2403
> also check out the xp_smtp_sendmail alternative as this should be alot
> easier to implement.
>
> You should also look at calling sp_OAGetErrorInfo to get error details.
>
> John
>
> "viktor" wrote:
> 

Hi

There is probably some error in the declarations of the variables you are
using. Try the code from the link I previously posted or from
http://tinyurl.com/r47n3

John

"viktor" wrote:

> I am getting this  error description:
> Output values of type Object are not allowed in result sets
>
> "John Bell" < jbellnewsposts@hotma
il.com> wrote in message
> news:23B0BAE4-FE53-4859-A6D6- 97E00453FC1F@microso
ft.com... 
>
>
>