Actuate / Progress connection with local db on Win95
To connect Actuate directly to a local Progress database on a
standalone Win95 machine you must have the following Progress
products installed:
Personal Database or ProVision
You must set all of the following environment variables. You can
either set these at the autoexec.bat level or from a batch file where
you will be also starting the server and broker from:
SET DLC=C:\<your-8.2a-dlc-directory>
SET PROCFG=%DLC%\progress.cfg
SET PROMSGS=%DLC%\promsgs
PATH=%DLC%;%DLC%\BIN;%PATH%
SET PROOIBRK=%DLC%\BIN\oibrkr32.exe
SET PROOIDRV=%DLC%\BIN\oidrvr32.exe
Use the following connection parameters:
1) Start a server for the database:
i.e. %DLC%\BIN\_mprosrv.exe <database name>
Note: If you need to connect to another client w/o the OIB:
In the Connections Dialog Box, enter the database name
and check the box for Multiple Users. None of the connection
parameters need to be filled in.
2) Start an Open Interface Broker:
i.e. %DLC%\BIN\oibrkr32.exe -SV -S <service>
TCP/IP is assumed. Host is local.
Important note: Make sure that the broker is being started in the
same directory where the database is located. This is necessary
for a self-serving client.
You may get an error in the prooidrv.lg file stating that Connect
Named Pipe failed (6014). This is an erroneous error message
which can safely be ignored.
3) From Actuate:
DatabaseList: -db <db name>
Note: make sure NO path is being given towards the database!
DLLPath: <path>\esql32.dll * this is usually in
c:\DLC\BIN\
StartUpParameters: -SV -S <service> -N tcp -H localhost
Using -H <pcname> the connection is possible as well but the
connection time is logner.
To shut down the server: %DLC%\BIN\_mprshut <db name> -by
To shut down the broker: There is bug in 8.2A which may cause a GPF
if you try to shut down the broker with _mprshut. To shut down
the broker you may control+alt+delete, find the oibrkr in the list
of processes, and choose to end that task.
For more information on connecting across a network, see knowledge
base entry 16794 "Connecting to a Progress DB from Actuate Developer
Workbench".
Progress Software Technical Support Note # 16887