Kbase P3888: Getting error "Database already connected" when using Report Builder Engine
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/02/2008 |
|
Status: Unverified
SYMPTOM(s):
Getting error when using Report Builder Engine
Database <name> already connected
Using the PRORE Report Engine
The database also contains the Report Engine table
Report Builder
CAUSE:
The database containing your data also contains the Report Engine Table. Therefore, the database you connect to from the command line (or the RUN statement) is the same as the database in the RB-DB-CONNECTION parameter or saved in the report.
FIX:
Specify the parameter like this:
logicalname => logicalname
For example:
1 - Saved in report definition (.prl)
physical: sports.db
logical : progress
2 - Command line
PRORE.EXE -db sports.db -ld mysports
3 - The RB-DB-CONNECTION should have
progress => mysports, /* RB-DB-CONNECTION */
This maps the logical name stored in the report to the logical name of the database connected on the command line.
If a logical name was not specified when connecting to the database, the logical name defaults to the physical name without the .db extension.
For example:
1 - Saved in report definition (.prl)
physical: sports.db
logical :
2 - Command line
PRORE.EXE -db sports.db
3 - The RB-DB-CONNECTION should have
sports => sports, /* RB-DB-CONNECTION */