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.