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)
Connect to the host database as a user with RESOURCE authority.
In the left pane, double-click Remote Servers.
Select the remote server, and then choose File » Properties.
Alter the remote server settings, and then click OK.
To alter the properties of a remote server (SQL)
Connect to the host database as a user with DBA authority.
Execute an ALTER SERVER statement.
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.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|