Kbase P8530: Unable to establish Oracle connection, resulting in error 10
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/2/2003 |
|
Solution ID: P8530
FACT(s) (Environment):
DataServer
SYMPTOM(s):
<program name> non-PROGRESS database <name> unknown. (1008)
Error is seen when connecting through command line and/or through procedure editor
Connection String defined:
CMD: prowin32 -db schholder -1 -ld oradb -dt ORACLE -U user -P password
PE: connect -db schholder -1 -ld oradb -dt ORACLE -U user -P password
The "-db" is not defined for the ORACLE schema connection
CAUSE:
This connection string is missing the "-db" parameter for the ORACLE db. The -db is defined for the schema holder, however, not defined for the ORACLE schema image, the oracle db. The logical name is not enough, as it's not possible to identify where the oracle connection parameter starts.
FIX:
Add the "-db" parameter to your oracle connection string as follows. This parameter must be used.
prowin32 -db schholder -1 db oradb -dt ORACLE -U user -P password
The logical (-ld) parameter can also be used as well, but always inconjunction to the -db. Please note that the -dt parameter must follow after the -db and -ld, as it represents the ORACLE datatype.