Salesforce

How to make a database connection with the Progress Application Server (PASOE)

Printable View
« Go Back

Information

 
TitleHow to make a database connection with the Progress Application Server (PASOE)
URL NameHow-to-make-a-database-connection-with-the-Progress-Application-Server-PASOE
Article Number000183589
EnvironmentProduct: OpenEdge
Version: 11.7.x, 12.x
OS: All supported platforms
Other: Progress Application Server for OpenEdge (PASOE), RDBMS
Question/Problem Description
How to make a database connection with the Progress Application Server (PASOE)
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution

A database connection for a Progress Application Server can be configured in three places:

  1. OpenEdge Explorer (OEE) or OpenEdge Management (OEM)
    1. ​Navigate to the ABL application configuration: Resources -> Progress Application Server -> oepas1 -> ABL Applications -> Configuration.
    2. Specify the connection parameters in the 'Agent startup parameter' field under the 'Startup Parameters and Environment' tab.
  2. ​​​In DeveloperStudio
    1. ​Double-click on your PAS instance in the Servers view to open the Overview page.
    2. Click on the 'open launch configuration' link to open the configuration overview.
    3. Select the database.
    4. Click 'Apply' and 'OK' to close the launch configuration (NOTE: The PAS instance has to be started for the configuration to be synchronized).
  3. ​Via Program at Agent Startup
    1. ​Follow steps 1.1 or 2.1 through 2.2.
    2. Add the name of the program you want to run at agent startup to connect to the databases to the 'Startup Procedure' field. 
  4. Editing the PAS instance OpenEdge.Properties file (${catalina.base}/conf/openedge.properties):
    1. Open the OpenEdge.properties for the PAS instance and add database parameters as follow:
[AppServer.SessMgr.<instancename>]
    agentLogEntryTypes=ASPlumbing,DB.Connects
    agentLogFile=${catalina.base}/logs/<instancename>.agent.log
    agentStartupParam=-T "${catalina.base}/temp" -pf <pffilename>.pf 

or

[AppServer.SessMgr.<instancename>]
    agentLogEntryTypes=ASPlumbing,DB.Connects
    agentLogFile=${catalina.base}/logs/<instancename>.agent.log
    agentStartupParam=-T "${catalina.base}/temp" -db <dbname> -S <port> -N <protocol> -H <hostname> 

 
Workaround
Notes
Keyword Phrase
Last Modified Date12/12/2024 4:38 PM
Powered by