|
Home > Archive > SQL Anywhere database > December 2005 > xp_sendmail
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Irineu Dewes 2005-12-21, 1:23 pm |
| Hi,
Can I use xp_sendmail without MS Exchange?
this example donīt work
in ISQL
create variable rc INTEGER;
rc = call xp_startsmtp(smtp_se
nder ='user@terra.com.br',smtp_server =
'smtp.poa.terra.com.br');
rc=call xp_startmail(mail_us
er='user@terra.com.br',mail_password ='xxxxx');
this return 21 Login failure.
rc = CALL xp_sendmail( recipient='com.br',
subject='Teste',"message"='TESTE');
call xp_stopmail();
call xp_stopsmtp();
Any Ideas?
| |
| Dmitri 2005-12-21, 1:23 pm |
| Irineu Dewes wrote:
> Can I use xp_sendmail without MS Exchange?
Yes, if SMTP server is available.
> rc = call xp_startsmtp(smtp_se
nder ='user@terra.com.br',smtp_server =
> 'smtp.poa.terra.com.br');
> rc=call xp_startmail(mail_us
er='user@terra.com.br',mail_password ='xxxxx');
> this return 21 Login failure.
You should deside whether you'll send mail through MAPI or SMTP, and use
either xp_startmail() or xp_startsmtp() respectively.
Dmitri.
| |
| Breck Carter [TeamSybase] 2005-12-21, 1:23 pm |
| You do not need Exchange... chances are, it would not work anyway :)
You need an SMTP server that will act as a relay as far as your
messages are concerned. For example, 602LAN Suite (software602.com)
offers the ability to restrict relaying to emails sent by authorized
user ids and originating from specific IP addresses. For example, you
use a sender id that is defined in the SMTP server setup, and you tell
the SMTP what the IP address of the ASA server is.
You don't want to set up an "open relay" SMTP server... very quickly,
the Internet world will make your life difficult (e.g., ordb.com).
What is smtp.poa.terra.com.br? Is it an actual SMTP server? Does it
allow relaying? Is user@terra.com.br a real user on that server?
Breck
On 21 Dec 2005 09:47:29 -0800, "Irineu Dewes" <irineu@wesa.com.br>
wrote:
>Hi,
>
>Can I use xp_sendmail without MS Exchange?
>this example donīt work
>
>in ISQL
>
>create variable rc INTEGER;
>rc = call xp_startsmtp(smtp_se
nder ='user@terra.com.br',smtp_server =
>'smtp.poa.terra.com.br');
> rc=call xp_startmail(mail_us
er='user@terra.com.br',mail_password ='xxxxx');
>this return 21 Login failure.
>
>rc = CALL xp_sendmail( recipient='com.br',
> subject='Teste',"message"='TESTE');
>call xp_stopmail();
>call xp_stopsmtp();
>
>Any Ideas?
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|