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.
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 ECDA Option for Oracle Service.
If you are connected directly to ECDA Option 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 ECDA Option 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.
