ASA SQL User's Guide
  Accessing Remote Data
    Working with remote servers
      Creating remote servers

Creating remote servers using Sybase Central

You can create a remote server using a wizard in Sybase Central. For more information, see Creating remote servers.

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 Remote Server Creation wizard appears.

4. On the first page of the wizard, enter a name to use for the remote server. This name simply 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 an appropriate type of server and click Next.

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

   • For ODBC, supply a data source name.

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

   The data access method (JDBC or ODBC) is the method used by Adaptive Server 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. Specify whether you want the remote server to be read-only.

8. Click Finish to create the remote server definition.