Release 10.1A: OpenEdge Development:
Progress Dynamics Administration

> ## Configuring OpenEdge DataServer for Oracle

> This section provides an example of setting up the connection with the OpenEdge OracleŽ DataServer. You must supply the following connection parameters when you set up the connection to the schema holder database:

>     -db Progress_schema_holder_name -H host -S service -N TCP
>     -db Oracle_db_name -ld same_Oracle_name -dt ORACLE
>     -U "name/password@Oracle_instance" -H broker_host -S broker_service

> You first supply the startup parameters for the schema holder database (`Progress_schema_holder_name`, etc.). The remaining parameters are used to start the DataServer connection to the non-OpenEdge database (`Oracle_db_name`, etc.).

> The following example shows how this information is stored in the `icfconfig.xml` configuration file:

>     - <service>
>       <cServiceType>Database</cServiceType>
>       <cServiceName>ORA</cServiceName>
>       <cPhysicalService>ORAn</cPhysicalService>
>       <cConnectParams>-db sh_oratest -N TCP -H client_system -S demo_svc1
>         -db ora_db -ld ora_db -dt ORACLE -U "icftest/icftest@test821"
>         -H server_system -S demo_svc2</cConnectParams>
>       <lDefaultService>no</lDefaultService>
>       <lCanRunLocal>yes</lCanRunLocal>
>       <iStartOrder>0</iStartOrder>
>       </service>

> Some important points:

> - For Oracle, the database type is always ORA.

> - For the Oracle connection, you must use double quotes around the user name and password. If double quotes are not used, Progress Dynamics might incorrectly parse the connection string.

> - The `-ld` and `-dt` parameters are optional.

> - If the schema holder is on the same machine as the client, then the `-H` and `-S` parameters for the schema holder are optional.

> - In this example, the second set of `-H` and `-S` parameters specify the location of the database broker. If the database broker is located on a different machine than where the client is running, you must specify the `-H` and `-S` parameters.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095