Kbase P11100: Can Progress client connect to multiple schema holders?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/5/2008 |
|
Status: Verified
GOAL:
Can Progress client connect to multiple schema holders?
GOAL:
Can Progress connect to several ORACLE databases through the 4GL/procedure editor?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
Oracle DataServer
FIX:
Yes, a Progress client can connect to several ORACLE databases through the 4GL/procedure editor.
These ORACLE databases/images can reside in 1 schema holder or multiple schema holders depending on your configuration.
For example, say that you would like to connect to multiple schema holders which each have a different ORACLE image. Here, you can connect the schema holder at startup, then connect to the ORACLE image using the Progress CONNECT statement. Or you can connect to schema holder and ORACLE image via the CONNECT statement. Any combination of connection technique will work, as long as you follow these steps:
1. Connect the schema holder
2. Connect the ORACLE database.
Following is a simple CONNECT statement to do this.
Schema Holder 1: CONNECT schema1 ... -db oracle1 -dt ORACLE ....
Schema Holder 2: CONNECT schema2 ... -db oracle2 -dt ORACLE ....
If you are using a remote DataServer, you must have a broker on the host machine before you can connect. This connection string must be entered after connecting to the ORACLE image/db.