Kbase P132562: How to make a read-only connection to the database in OpenEdge Architect
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/25/2008 |
|
Status: Unverified
GOAL:
How to make a read-only connection to the database in OpenEdge Architect
GOAL:
How to connect for read-only access in DB Navigator
FACT(s) (Environment):
Windows
OpenEdge 10.1x
FIX:
OpenEdge Architect uses two different types of database connection depending on which perspective is being used. A read-only connection can be specified for either type, but the syntax is slightly different for each.
Progress DB Navigator provides a graphical, interactive environment for database access using SQL. It connects to the OpenEdge database through a SQL server using JDBC. Use the following steps to create a connection profile for read-only database access through DB Navigator:
Start the database with a SQL broker by setting the -ServerType startup parameter to "Both" (default) or "SQL".
Add a connection profile to OpenEdge Architect:
From the main menu, choose Window>Open Perspective>OpenEdge DB Navigator. The Connections tab will appear on the left.
Click the "Add Connection Profile" icon (second from the left; mouse over to verify the name). Choose a name for the connection, and specify connection details appropriate for the broker you have started (database name and service or port).
In the "Additional startup parameters" section, specify "RO=true" (do not type the quotes).
Click Test Connection to verify that the connection works, correct if necessary, and click OK.
To connect to the database, select the connection profile from the list in the Connections view and click the "Open Connection" icon (third from the left; mouse over to verify the name).
OpenEdge projects can be developed in the OpenEdge Editor and/or OpenEdge Appbuilder perspectives. They connect to the OpenEdge database through a 4GL server; they need at least read-only database access in order to compile correctly. Use the following steps to create a read-only connection in an OpenEdge project:
Start the database with a 4GL broker by setting the -ServerType startup parameter to "Both" (default) or "4GL".
Create a database connection in the project:
From the main menu, choose Project>Properties.
From the list in the frame on the left, expand OpenEdge, then click Database Connections.
Click the "Configure database connections..." link.
From the "Database Connections" dialog that appears, click New.
In the "Add OpenEdge Database Connection" dialog, specify connection details appropriate for the broker you have started (database name and service or port).
In the "Other parameters" section, specify "-RO" (do not type the quotes).
Click Test Connection to verify that the connection works, correct if necessary, and click Next.
Click Finish.
From the "Database Connections" dialog, click OK.
In the Properties dialog, the new connection will appear in the list. Check the box beside it, then click OK.
A read-only database connection will be made each time the project is opened.