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

Creating remote servers using Sybase Central

You can create a remote server using a wizard in Sybase Central.

To create a remote server (Sybase Central)

1. Connect to the host database from Sybase Central.

2. Open the Remote Servers folder for that database.

3. From the File menu, choose New > Remote Server.

   The Create Remote Server wizard appears.

4. On the first page of the wizard, enter a name to use for the remote server. This name refers to the remote server from within the local database; it does not need to correspond with the name the server supplies. Click Next.

5. Select the appropriate type of server, and then click Next.

6. Select a data access method (ODBC or JDBC), and supply connection information.

   • For ODBC, supply a data source name or specify the ODBC Driver= parameter.

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

   • Click Next.

   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. Specify whether you want the remote server to be read-only. Click Next.

8. Create an external login for the remote server.

   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.

9. Optionally, you can click Test Connection to test whether you can connect to the remote server before the remote server definition is created.

   Click Finish to create the remote server definition.