Progress
Basic Database
Tools


Utilities>Edit Progress Auto-Connect List

Choose Utilities Edit Progress Auto-Connect List to create or modify the auto-connect list. The auto-connect list is a list of secondary Progress databases (with connection parameters) that Progress connects automatically as required during program execution on a primary database. You can define one for each Progress database.

NOTE: To use the Auto-Connect feature for non-Progress databases, use the Edit Connection Parameters option under the appropriate DataServer submenu option. See the appropriate Progress DataServer manual for information on auto-connecting to non-Progress databases.

The Progress auto-connect feature uses information stored in a primary application database to connect to a secondary application database. The primary application database contains the database connection information for the secondary database. When data from the second database is referenced in a compiled application at run time, the primary application database must already be connected before Progress can execute the auto-connect for the secondary application database. Progress executes an auto-connect immediately prior to running a procedure that accesses a database on the auto-connect list. If you connect a database with the CONNECT statement, and that database also has an auto-connect entry in an already connected database, the CONNECT statement uses the information from the auto-connect list; however, the explicit connection information in the CONNECT statement takes precedence. For more information about auto-connect, see the chapter on database access in the Progress Programming Handbook.

When you choose this option, the Edit Auto-Connect List window shown in Figure 11–10 appears.

Figure 11–10: Edit Progress Auto-Connect List Window

This window contains the following user-interface elements:

Database Name

Displays the list of databases to which Progress connects automatically.

Logical Database Name

Specifies the logical name of the database highlighted in the Database Name list.

Physical Database Name

Specifies the physical name of the database highlighted in the Database Name list.

CONNECT-Statement Parameters

Specifies any other startup parameters for the database that are not included in the parameter file. Progress Software Corporation recommends that you specify all parameters in the parameter file.

Table 11–5 describes the buttons on the Edit Auto-Connect List dialog box.

Table 11–5: Edit Auto-Connect List Options 
Option
Action
Next
Displays the next connect record.
Prev
Displays the previous connect record.
First
Displays the first connect record.
Last
Displays the last connect record.
Add
Adds a new connect record.
Modify
Modifies the selected connect record.
Delete
Deletes the selected connect record.
Undo
Exits, undoes all changes you made in this session to the Auto Connect list, and returns to the Data Administration window.
Exit
Exits, saves changes, and returns to the Data Administration window.


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