Configuring the Progress Application Server for OpenEdge agent as a self-service DataServer session

To configure the Progress Application Server for OpenEdge agent as a self-service DataServer session:
  1. Create a schema holder.
  2. Specify the MS SQL Server instance username (-U) and password (-P) connection parameters for the schema holder.
  3. Create a Progress Application Server instance. For example:
    pasman create -p 8811 -P 8812 -s 8813 $WRKDIR/pasds
    Note: For more information on how to create a Progress Application server instance, see the Progress Application Server for OpenEdge for OpenEdge: Administration Guide.
  4. Set the value of agentStartupParam in the openedge.properties file as follows to start the agent and connect to the schema holder:
     agentStartupParam=-T "${catalina.base}/temp" -pf $WRKDIR/mss.pf 
    Note: The openedge.properties file is located in the $WRKDIR/pasds/conf folder. You can also connect the schema holder and database
  5. Start the tomcat server using proenv as follows:
    $WRKDIR/pasds/bin/tcman.bat start
    Note: The agent log is located in $WRKDIR/pasds/logs/pasds.agent.log
  6. Connect to the server code using client.p as shown below:
    DEFINE  VARIABLE            hServer AS           HANDLE      NO-UNDO.
                                        CREATE SERVER hServer.
                                        hServer:CONNECT("-URL http://localhost:8811/apsv -AppService nxgas -sessionModel       Session-Free").
                                        IF NOT   hServer:CONNECTED()    THEN     DO:
                                                       MESSAGE "Failed to connect to AppServer".
                                                       RETURN.
                                        END.
                                        run server.p        on          hServer.
                                        hServer:DISCONNECT().
                                        DELETE OBJECT hServer.