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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Accessing Remote Data » Working with remote servers

Deleting remote servers Next Page

Altering remote servers

You can use Sybase Central or an ALTER SERVER statement to modify the attributes of a server. These changes do not take effect until the next connection to the remote server.

You must have RESOURCE authority to alter a server.

To alter the properties of a remote server (Sybase Central)
  1. Connect to the host database from Sybase Central.

  2. Open the Remote Servers folder for that database.

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

  4. Configure the various remote server properties, and then click OK.

To alter the properties of a remote server (SQL)
  1. Connect to the host database from Interactive SQL.

  2. Execute an ALTER SERVER statement.

  3. 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.

    CLASS 'aseodbc';

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