Kbase P79351: How to compile .r code with oracle DataServer license if 4GL license is installed in a different loc
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/09/2008 |
|
Status: Verified
GOAL:
How to compile .r code with oracle DataServer license if 4GL license is installed in a different location?
GOAL:
How do I compile .r code with MS SQL server DataServer license if 4GL license is installed in a different location?
GOAL:
How do I compile .r code with ODBC DataServer license if 4GL license installed in a different location?
GOAL:
How to compile application against Oracle database if 4GL and Oracle database license are not at the same location?
FACT(s) (Environment):
DataServers
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
To compile code against foreign database types, only schema holder needs to be connected in the compile session, no actually connection to foreign database is necessary. Perform following steps:
1. Create schema holder from DataServer installation, use -rx starting the session
2. After schema holder is created, disconnect from the first session, switch environment to 4GL installation
3. Connect to schema holder in -RO mode, select foreign database as working database, but select "no" when asked whether you want to connect to data source.
4. Compile the code
5. Disconnect from 4GL session, and switch environment to DataServer installation run the .r code