DNS in xp_startsmtp

[Former Member]

I'm having trouble with the xp_startsmtp in SQLA 12.0.1.  When I ping aspmx.l.google.com from the server the db is on, it resolves the name properly, but when I try to use that server name in xp_startsmtp, it faile with error 102, which is a name resolution failure.  If I plug in the IP address instead of the server name, it works fine.

What am I missing in the DB server's DNS capabilities?

Dave

[former_member188493 · Accepted solution]

You might have better luck asking the question on SAP SQL Anywhere Forum

FWIW I can ping that domain, but V12 xp_startsmtp gives error code 100 socket error for both the domain and the IP. The V16 xp_startsmtp give error code 5 connect error and secondary code 10060 timeout for both the domain and IP. In no case does it get far enough to give a password error... probability is high that none of that is going to help you :]