Gerald Landl
|
| Posted: 03/17/2002, 7:55 AM |
|
Hallo,
first of all I think your Connection is not connected to the master Database
therefor you have to use a fully qualified name for the Procedure Call
master..xp_sendmail should work.
next error xp_sendmail does not open a Recordset, it only writes mails to
your mail storage, so you should not write "set sql = ...."
Another hint is: You should call xp_startmail before and xp_stopmail after
you call xp_sendmail.
lg Gerald
"William Raymond" <braymond@officecollab.com> wrote in message
news:a458h7$phf$1@news.codecharge.com...
> Hello,
>
> I apologize for all the questions, but I am re-learning quite a bit here.
>
> I am trying to run the SQLMail Stored Procedure in SQL 2000 using ASP. I
> know SQLMail is configured, because I went to the Enterprise Manager and
ran
> the Query Analyzer and ran the xp_sendmail stored procedure. So... I
copied
> the entire line and created what I thought would generate the Stored
> Procedure. Instead, I get an error in the ASP page that says:
>
> Could not find stored procedure 'xp_sendmail'.
>
> Anyone know what the deal is? Here is the code I generated (I tried it so
> many ways and always end up with the same error:
>
> set sql = cn.execute("xp_sendmail
> @recipients='braymond@officecollab.com',@subject='testsubject'")
> sql.close
>
> Thanks again for your help,
>
> -Bill
>
>
|
|
|
 |
|
