Define a SQL connection profile

Demo

Defining Workspace Database Connections

Note: The OpenEdge Release 10.2B demos have not been updated for OpenEdge Release 11.0. Since 10.2B, OpenEdge Architect has been renamed as Progress Developer Studio for OpenEdge. In addition, OpenEdge Release 11.0 includes some feature enhancements and other changes. Despite the differences between 10.2B and 11.0, the demos are still a useful introduction to Progress Developer Studio for OpenEdge.

When you create a new database connection using the connection profile wizard, you can specify whether or not to define a SQL connection. A SQL connection is necessary to display the tables and columns in the DB Structure View.

The following options are available on the Define a SQL connection profile page:

Define SQL connection When this checkbox is selected, you can define a new SQL connection, or you can assign a connection that already exists.
Add new SQL connection The Add new SQL connection radio button indicates that the connection profile uses a new SQL connection. Select this option, then click Next to display the Add New SQL Connection Profile page.
Use existing SQL connection The Use existing SQL connection radio button indicates that the connection profile uses a previously defined SQL connection. Existing connections are listed. To assign an existing connection, select the checkbox nearest the connection profile and click Next. The next page in the connection profile wizard (Define Database Server configuration) appears.
Note: When you select the Use existing SQL connection radio button, items in the browser become selectable.

Database connection profiles

See OpenEdge Data Management: SQL Development and OpenEdge Data Management: SQL Reference manuals for more information on SQL connections. You can find OpenEdge manuals in the Product Documentation section of the Progress Software Developer's Network Web site.