Adding a service

To use an additional Oracle database, you must add a new service. To add a new service, you can use DirectConnect Manager or you can use sp_addservice.

Using DirectConnect Manager

For instructions on how to use DirectConnect Manager to add a new service, go to the DirectConnect Manager online Help, and select Managing Access Service | Creating a new DirectConnect for Oracle (DCO) Service.

Using sp_addservice

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

exec sp_addservice service_name

or, if you are connected through Adaptive Server:

DCServer... sp_addservice service_name

These methods add a new service to the DirectConnect for Oracle and write the service entry into the configuration file.

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.