Wednesday, February 8, 2012

Setting dbremote mail replication options via isql in SQL Anywhere

When you extract databases from a SQL Anywhere server you can then enter the mail settings on first run of dbremote.

When you are running dbremote as a service (under either linux or windows) then you will not see the dialog asking for the mail settings.

To prevent this you can enter the parameters via normal sql commands.
Here a example on how to configure the mail replication (smtp+pop3)


set remote smtp option smtp_host='smtp.domain.com'
set remote smtp option pop3_host='pop.domain.com'
set remote smtp option pop3_userid='mailaccount@domain.com'
set remote smtp option pop3_password='password'