Administrators can use Sybase Central to delete directory access servers.
You must have the SERVER OPERATOR system privilege.
All proxy tables defined for the directory access server must be dropped before dropping the directory access server. The following query can be used to determine which proxy tables are defined for the directory access server server-name.
SELECT st.table_name, sp.remote_location, sp.existing_obj FROM sysproxytab sp JOIN sysserver ss ON ss.srvid = sp.srvid JOIN systab st ON sp.table_object_id = st.object_id WHERE ss.srvname = 'server-name';
Context and remarks
You cannot alter an existing directory access server: you must drop the existing directory access server using a DROP SERVER statement, and then create a new one.
Use the SQL Anywhere 16 plug-in to connect to the host database.
In the left pane, double-click Directory Access Servers.
Select the directory access server, and then click Edit » Delete.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|