Progress
Report Builder
User’s Guide


Connection Information

This section describes the following database connection issues:

Single-user Databases

Report Builder cannot connect to a single-user database that is already in use in a Progress session. In particular, if you are running the ADE and are connected to a single-user database, you cannot run Report Builder from your ADE session to execute a report against the same database.

Read-only (-RO) Parameter

Do not use the Read-only parameter when connecting to databases with Report Builder. If you want to run the Report Builder against a database that is also in use by another process (for example, the ADE), you must use a database server to allow multi-user access to the database. The -RO parameter tells Report Builder to assume that the disk file containing the database has all the information about the database; however, if another process (such as the ADE) is accessing the database, then some of the database information will be in buffers in memory, not on disk. This means that Report Builder would be getting inaccurate information about the database, and might generate reports containing incorrect data or might encounter a fatal error.

Parameter Files

You can specify multiple database connections in parameter files when you start Report Builder and Report Engine from the command line. Report Builder and Report Engine read a parameter file during startup or when you connect to a database; they do not read the file when they open an existing report. Therefore, you can change the parameters stored in a parameter file without affecting an existing report. You can do this because Report Builder and Report Engine read all the connection information out of the file and store individual connections with all the corresponding parameters.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095