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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Accessing remote data » Working with remote servers


Create remote servers

 To create a remote server (Sybase Central)
  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. See CREATE EXTERNLOGIN statement.

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

  11. Click Finish.