|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sp_send_cdosysmailWe've just created the "sp_send_cdosysmail" stored procedure on our sql
server box. When running the test call from Query Analyzer to see if it works, we get back the message: "-2147220978". We've searched and searched, and we can't find this error listed anywhere. Does anyone know what this means? Thanks. Can you post your DDL? It looks like the data type has problem, just guess.
Perayu Show quote "David" <Da***@discussions.microsoft.com> wrote in message news:B04478DB-183F-4B14-A27B-FFF35303080B@microsoft.com... > We've just created the "sp_send_cdosysmail" stored procedure on our sql > server box. When running the test call from Query Analyzer to see if it > works, we get back the message: "-2147220978". We've searched and > searched, > and we can't find this error listed anywhere. Does anyone know what this > means? > > Thanks. Have you considered xp_smtp_sendmail? See http://www.aspfaq.com/2403
This is translated to error 0x8004020E (you can do this ). It is possible that this is caused by (a) your SMTP server will not allow relay for the IP address you are sending from, the domain you are sending from, or the domain you are sending to; or (b) your SMTP server requires outgoing authentication (much more prevalent these days). Try running the CDO code OUTSIDE of SQL Server (e.g. from a .vbs script) and see if you can't get more detailed messages there. You can also try a different SMTP server. For the VBS syntax involving outgoing authentication, see http://www.aspfaq.com/2026 (sorry, you'll have to translate this to T-SQL and sp_OA syntax yourself). But I still recommend straightening out your SMTP server and using xp_smtp_sendmail as opposed to CDO. A Show quote "David" <Da***@discussions.microsoft.com> wrote in message news:B04478DB-183F-4B14-A27B-FFF35303080B@microsoft.com... > We've just created the "sp_send_cdosysmail" stored procedure on our sql > server box. When running the test call from Query Analyzer to see if it > works, we get back the message: "-2147220978". We've searched and > searched, > and we can't find this error listed anywhere. Does anyone know what this > means? > > Thanks. > This is translated to error 0x8004020E (you can do this .... using calc.exe in scientific view. Take the big number you got, paste into Decimal view, and then switch to Hex view. Thanks for your reply.
Nothing seems to help. Tried direct calls through Query Analyzer and via from within client app. In addition to sending emails from within .net client apps, we also need to send email via the Reporting Services subscriptions. Would we be able to do this if we went the xp_smtp_sendmail route? Show quote "Aaron Bertrand [SQL Server MVP]" wrote: > Have you considered xp_smtp_sendmail? See http://www.aspfaq.com/2403 > > This is translated to error 0x8004020E (you can do this ). It is possible > that this is caused by (a) your SMTP server will not allow relay for the IP > address you are sending from, the domain you are sending from, or the domain > you are sending to; or (b) your SMTP server requires outgoing authentication > (much more prevalent these days). > > Try running the CDO code OUTSIDE of SQL Server (e.g. from a .vbs script) and > see if you can't get more detailed messages there. You can also try a > different SMTP server. > > For the VBS syntax involving outgoing authentication, see > http://www.aspfaq.com/2026 (sorry, you'll have to translate this to T-SQL > and sp_OA syntax yourself). But I still recommend straightening out your > SMTP server and using xp_smtp_sendmail as opposed to CDO. > > A > > > > "David" <Da***@discussions.microsoft.com> wrote in message > news:B04478DB-183F-4B14-A27B-FFF35303080B@microsoft.com... > > We've just created the "sp_send_cdosysmail" stored procedure on our sql > > server box. When running the test call from Query Analyzer to see if it > > works, we get back the message: "-2147220978". We've searched and > > searched, > > and we can't find this error listed anywhere. Does anyone know what this > > means? > > > > Thanks. > > > > send email via the Reporting Services subscriptions. Would we be able to Well, <something> calls sp_send_cdosysmail, right? Couldn't <something> > do > this if we went the xp_smtp_sendmail route? call xp_smtp_sendmail just as easily?  |
|||||||||||||||||||||||
Other interesting topics