iAnywhere.com - Creating remote servers using Sybase Central

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)

Connect to the host database from Sybase Central.
Open the Remote Servers folder for that database.
From the File menu, choose New > Remote Server.

The Remote Server Creation wizard appears.
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.
Select an appropriate type of server and then click Next.
Select a data access method (ODBC or JDBC), and supply connection information. Click Next.
- 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.
Specify whether you want the remote server to be read-only. Click Next.
Create an external login for the remote server.

By default, Adaptive Server 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.
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.