Kbase P46278: RB. Cannot override the Oracle schemaholder connection param
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/10/2003 |
|
Status: Unverified
SYMPTOM(s):
Cannot override the Oracle schemaholder connection parameters using RB-DB-CONNECTION
Accessing Report Builder report via Runtime Engine
Report Builder
CAUSE:
The database source identified by Report Builder is the Oracle database itself, not the schemaholder. therefor it is not possible to override the connection string for the schemaholder.
FIX:
If you have developed the report using the following connection string:
schemaholder -S ServiceNameSH -H hostnameSH -db dbnameOD -dt Oracle -H hostnameOD -S ServiceNameOD
In the report engine you can use this RB-DB-CONNECTION override:
dbnameOD = -db dbnameOD -dt Oracle -H hostnameOD -S ServiceNameOD
and not:
schemaholder = -db schemaholder -S ServiceNameSH -H hostnameSH -db dbnameOD -dt Oracle -H hostnameOD -S ServiceNameOD -U username -P password
This string will be ignored because Report Builder doesn't recognize "schemaholder " in any of his DB source. This is a limitation of Report Builder and due to its mature state, it is not possible to proceed to an enhancement it.