Try OpenEdge Now
skip to main content
Configuring Multi-tenancy
Configuring database connections : Establishing a database connection : Setting up the connection : Establishing a connection to a local or remote scripted database
 
Establishing a connection to a local or remote scripted database
If the database is not being managed from within OpenEdge Management/OpenEdge Explorer, you can start the database on the machine where it is located (either the local host or a remote host) using the command line. You can then use the Database Administration Console to work with that database once you define a connection to it.
When you define a scripted database on a remote AdminServer, be sure to use localhost as the database's host. This allows the ABL commands to execute on the remote AdminServer and connect to the database by using shared memory.
When you use localhost, the database is included in both the Resources list in OpenEdge Management/OpenEdge Explorer and the Database Administration Console's Connections list. If you do not use localhost, the database is still listed as a resource but does not appear in the Connections list.
If you do not define the host as localhost for the scripted database on the remote AdminServer, you must add the database connection manually and specify the host and port required for the connection. In this case, the connection to the database is performed using the -H (host name) and -S (service name or port) parameters, and the database appears in the Connections list but not the Resources list in the management console.
To establish a connection to a scripted database:
1. On the machine where the scripted database resides (either the local host or a remote host), start Proenv (by choosing Start > Programs (or All Programs) > Progress > OpenEdge > Proenv).
2. Type the following command to start the database:
proserve { db-name | -servergroup [ server-group-name ] [ parameters ] }
3. Exit Proenv.
4. To add the database to the list of database resources, perform the following steps on the machine where OpenEdge Management/OpenEdge Explorer is installed.
5. Select Resources > New > Scripted Database in the management console.
The Create Scripted Database Monitor page appears.
6. Complete the page:
a. Provide the following information:
*Name — Name of the database.
*Description — A description of the database (optional).
b. Type the host name.
c. Provide an IP Address (optional).
d. Select the TCP/IP version (IPv4 or IPv6).
e. Type the complete path to the database.
f. To enable the scripted database after creation, select the Enabled option.
g. Click Save.
The Database details page appears
7. Click Control.
8. Choose one:
*If you are connecting to a scripted database on the local host:
1. Copy the command line from the Command line to start Monitoring Agent.
2. Start Proenv, and paste the command line details at the prompt.
3. Exit Proenv.
*If you are connecting to a scripted database on a remote host:
1. On the local host, note the command line from the Command line to start Monitoring Agent.
2. Start Proenv on the remote machine.
3. Type the command line details at the prompt.
4. Exit Proenv.
9. From the management console on the local host, return to the Database details page. The database and the database agent are now running.
For a local or remote scripted database in the database connections list, you can also:
*View details about a scripted database connection on the database home page. For more information, see Managing multi-tenant databases.
*Copy a scripted database connection.