Kbase 41100: Can Progress connect to several oracle databases through the 4GL/procedure editor?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Solution ID: P11100
GOAL:
Can Progress connect to several oracle databases through the 4GL/procedure editor?
FIX:
Yes, Progress can connect to several schema holders and thus, their corresponding Oracle databases.
You can use different connection techniques in combination with each other. For example, you can connect the schema holder at startup, then connect to the Dataserver image using the Progress CONNECT statement. Any combination of conenction techniques works, as long as you follow these steps:
1. Connect the schema holder
2. Connect the ORACLE database. If you are using a remote DataServer, you must have a broker on the host machine before you can connect.
Use the CONNECT statement to do this.
CONNECT schema1 ... -db oracle1 -dt ORACLE ....
CONNECT schema2 ... -db oracle2 -dt ORACLE ....