Removing a service

To remove a service, you can use DirectConnect Manager or you can use sp_dropservice.

Using DirectConnect Manager

For instructions on how to use DirectConnect Manager to remove a service, go to the DirectConnect Manager online Help, and select Managing Access Service | Removing a Service.

Using sp_dropservice

If you are connected directly to DirectConnect for Oracle, use the following syntax:

exec sp_dropservice service_name

or, if you are connected through Adaptive Server:

DCServer... sp_dropservice service_name

These commands remove an existing service from the DirectConnect for Oracle and delete the service entry from the configuration file.