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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Remote data access » Remote servers


Creating remote servers

Administrators can use Sybase Central to create remote server definitions.


DBA authority.

Context and remarks


 Create a remote server
  1. Use the SQL Anywhere 12 plug-in to connect to the host database as a user with DBA authority.

  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 ODBC, supply a data source name or specify the ODBC Driver = parameter.

    • For JDBC, 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.

  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.



 See also