Adding a SQL connection profile for an OpenEdge database

Click Add Connection Profile

Type a unique name in the Name field.

Select the Progress OpenEdge JDBC Driver(DataDirect) from the driver selection list.You can click New Driver if you need to configure a driver. In most cases, however, the driver is installed and configured automatically during installation of Progress DB Navigator. SQL can have multiple JDBC connections.Notice that the format for the selected driver's URL appears in the URL field. If necessary, you can edit the text in the URL field to include the appropriate information for your system.

To edit a URL:

Deselect the Specify URL Details checkbox (by default, this checkbox is selected, preventing you from editing the URL field).
Supply a hostname (use localhost if the host is local to the system). If you are using an IPv6 address, insert a bracket before and after the address; for example, [thehostmachine].
Type the port number.
Type the database name.

Note: Since the format of the URL and the required information can vary from driver to driver, see the documentation for your driver if you need more information.

Type the user name and password. If there are authenticated users in the database, enter a valid user ID and password. These are used as the default when opening the connection. If no authenticated users exist, enter a user ID that corresponds to the Windows login name of the user who created the database.

Note: You must specify the user ID when creating a SQL connection.

Select Open on Eclipse startup if you want the connection to open when Eclipse starts (provided the database server is already started).

Note: You still must enter a valid user ID and password. Also, be aware that opening database connections slows the startup of Eclipse.

Select Auto-Login on connect to automatically log into the database when connecting.

Type the name of the Host.

Note: If you are connecting to an OpenEdge Personal database (which is the default RDBMS packaged with Progress Developer Studio for OpenEdge), the host name must be localhost. You cannot connect to an OpenEdge Personal RDBMS database running remotely. If you are connecting to an OpenEdge Workgroup or OpenEdge Enterprise database, you can specify the host name of the system where the database server process is running. If the database is running on the local system, you can use localhost in place of the host name.

Select either Service or Port, and type the correct value. If you are unsure of the value, check the configuration settings for the database in OpenEdge Management or OpenEdge Explorer.

Type the logical name of the database in the Database field. Check for the correct name in the Databases folder in Progress Explorer.

Add any additional JDBC connection properties in the Additional parameters field, delimited by semicolons in the format key1=value; key2=value.

Click Test Connection to verify connectivity. If the connection succeeds, a Connection succeeded message appears. If the connection does not succeed, an error message appears.

Click OK.

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