Using a remote database on Windows

To use a remote database on Windows
  1. Select Control Panel >> Administrative Tools >> Data Sources (ODBC).

  2. Click the System DSN tab.

  3. Select AGDB and choose Configure.

  4. Click the Database tab and change the server name.

    The M-Business Server database name is <servername>_AGDB, where <servername> is the name of the server where the database is installed. Change the <servername> portion of the database name to the name of the remote server.

  5. Click the Network tab.

  6. Unselect all options exceptTCP/IP.

  7. In the box to the right of TCP/IP, replacing anything that is already there enter:

    port=<port>;host=<hostname>;broadcast=no

    Replace <port> with the port number of the SQL Anywhere server you want to connect to; the installation default is 8099.

    Replace <hostname> with the name or IP address of the server you want to connect to.

  8. Click the Login tab and click Supply user ID and password.

  9. For User ID, enter sync, and for Password, enter password.

    Note

    If you have changed the password for the sync user, enter your new password instead of password.

  10. Click OK to return to the ODBC Datasources Administrator.

  11. Click OK again to return to the Control Panel.