Changing the ECDA Option for Oracle Configuration

Change the configuration of ECDA Option for Oracle by modifying the configuration file.

Modify the configuration file using either:

Option Description

Option	Description
DirectConnect Manager	Go to the DirectConnect Manager online help to modify the configuration file. Select Managing Access Service > Modifying ECDA Option for Oracle Service Configuration Properties. When an ECDA Option for Oracle server is highlighted, the details pane Oracle Target field may show `Unable to make connection` for a service, which indicates that DirectConnect Manager could not connect to the target Oracle database. This may be due to the ECDA Option for Oracle administrator account being invalid on the target Oracle database or possibly using an incorrect password. If multiple services are configured in one ECDA Option for Oracle server and there are multiple target Oracle databases involved, Sybase recommends that you verify that the ECDA Option for Oracle administrator is a valid user on each of the target Oracle databases and that they all use the same password.
Command line	A configuration file is created automatically during installation. To display or edit the configuration options after installation, use sp_configure.

DirectConnect Manager

Go to the DirectConnect Manager online help to modify the configuration file. Select Managing Access Service > Modifying ECDA Option for Oracle Service Configuration Properties.

When an ECDA Option for Oracle server is highlighted, the details pane Oracle Target field may show Unable to make connection for a service, which indicates that DirectConnect Manager could not connect to the target Oracle database. This may be due to the ECDA Option for Oracle administrator account being invalid on the target Oracle database or possibly using an incorrect password. If multiple services are configured in one ECDA Option for Oracle server and there are multiple target Oracle databases involved, Sybase recommends that you verify that the ECDA Option for Oracle administrator is a valid user on each of the target Oracle databases and that they all use the same password.

Command line A configuration file is created automatically during installation. To display or edit the configuration options after installation, use sp_configure.