I try to send email from SQL Anywhere 18.104.22.16873 but xp_startsmtp return code 100 (Socket error). I closed firewall and antivirus.
li_ret = CALL xp_startsmtp( smtp_sender = 'firstname.lastname@example.org' , smtp_server = 'smtp.test.com' , smtp_port = 25 , timeout = 60 , smtp_auth_username = 'email@example.com' , smtp_auth_password = 'password' );
I'm afraid there isn't much I can tell you. SA 12 didn't have much in the way of diagnostics for the mail routines. In SA 16, you can get more detailed error messages.
As a test, start a command prompt and see if you can run 'telnet smtp.test.com 25'. If you successfully connect, then the problem is within SQL Anywhere.
answered 17 Feb '14, 08:36