Try OpenEdge Now
skip to main content
Managing ABL Applications
ABL and R-code Deployment and Management : Managing Client Access to Databases : Connecting clients to databases : Connection techniques : Connecting with auto-connect
Connecting with auto-connect
The OpenEdge auto-connect feature allows you to connect to databases automatically as required during program execution. To perform an auto-connect operation, OpenEdge uses information stored in a primary database to connect to a secondary application database, before running compiled procedures that access the second database. The primary database (the one that contains the auto-connect information for one or more additional databases) must be connected before OpenEdge can perform an auto-connect.
Use the Data Administration tool to build an auto-connect list for a primary database.
To create or to edit an auto-connect list:
1. Access the Data Administration tool.
2. Choose Edit Progress Auto-Connect ListUtilities. The Edit Auto-Connect List dialog box appears:
3. Enter or edit connection information for a database.
If you connect to a database with the CONNECT statement, and that database also has an auto-connect entry in an already connected database, the connection information from both the CONNECT statement and the auto-connect list is merged. In this situation, the connection information in the CONNECT statement takes precedence. For more information about the CONNECT statement, see OpenEdge Development: ABL Reference.
If the primary database is a schema holder for a DataServer schema, the DataServer schema is automatically included in the auto-connect list, but it does not appear on the auto-connect list as viewed from the Data Dictionary.