Altering remote servers

Changes to the remote server do not take effect until the next connection to the remote server.

To alter the properties of a remote server (Sybase Central)

  1. Connect to the host database as a user with RESOURCE authority.

  2. In the left pane, double-click Remote Servers.

  3. Select the remote server, and then choose File » Properties.

  4. Alter the remote server settings, and then click OK.

To alter the properties of a remote server (SQL)

  1. Connect to the host database as a user with DBA authority.

  2. Execute an ALTER SERVER statement.

Example

The following statement changes the server class of the server named RemoteASE to aseodbc. In this example, the Data Source Name for the server is RemoteASE.

ALTER SERVER RemoteASE
CLASS 'aseodbc';

The ALTER SERVER statement can also be used to enable or disable a server's known capabilities. See ALTER SERVER statement.