Adding a Service

Add a new service to use an additional Oracle database.

Use either of these options:

Option	Description
DirectConnect Manager	Go to the DirectConnect Manager online help, and select Managing Access Service > Creating a new ECDA Option for Oracle Service.
sp_addservice	If you are connected directly to ECDA Option for Oracle, use: exec sp_addservice `service_name` or, if you are connected through Adaptive Server, use: DCServer... sp_addservice `service_name` The interfaces file must contain both the `service_name` and the correct port number. Each service requires an entry in the interfaces file. The port numbers must be the same.

Option

Description

DirectConnect Manager

Go to the DirectConnect Manager online help, and select Managing Access Service > Creating a new ECDA Option for Oracle Service.

sp_addservice

If you are connected directly to ECDA Option for Oracle, use:

exec sp_addservice service_name

or, if you are connected through Adaptive Server, use:

DCServer... sp_addservice service_name

The interfaces file must contain both the service_name and the correct port number. Each service requires an entry in the interfaces file. The port numbers must be the same.