Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Remote data access » Remote servers


Creating remote servers (Sybase Central)

Administrators can use Sybase Central to create remote server definitions.


You must have the MANAGE ANY USER and SERVER OPERATOR system privileges.

 Create a remote server
  1. Use the SQL Anywhere 16 plug-in to connect to the host database.

  2. In the left pane, double-click Remote Servers.

  3. Click File » New » Remote Server.

  4. In the What Do You Want To Name The New Remote Server field, type a name for the remote server, and then click Next.

  5. Select a remote server type, and then click Next.

  6. Select a connection type, and in the What Is The Connection Information field type the connection information:

    • For an ODBC-based connection, supply a data source name or specify the ODBC Driver parameter and other connection parameters.

    • For a JDBC-based connection, supply a URL in the form computer-name:port-number.

    The data access method (JDBC or ODBC) is the method used by SQL Anywhere to access the remote database. This is not related to the method used by Sybase Central to connect to your database.

    JDBC-based remote server access is not supported in the current release.

  7. Click Next.

  8. Specify whether you want the remote server to be read-only and then click Next.

  9. Click Create An External Login For The Current User and complete the required fields.

    By default, SQL Anywhere uses the user ID and password of the current user when it connects to a remote server on behalf of that user. However, if the remote server does not have a user defined with the same user ID and password as the current user, you must create an external login. The external login assigns an alternate login name and password for the current user so that user can connect to the remote server.

  10. Click Test Connection to test the remote server connection.

  11. Click Finish.


A remote server is created with the specified definitions.


Create external login information if required.

 See also