Consultor Eletrônico

Intersolv ODBC V2.5: Environment required

This document explains the environment that needs to be set for every
configuration with the Intersolv OIDBC driver V2.5.


1. Settings on your PC for all configurations
------------------------------------------

The Intersolv ODBC driver needs several variable set at DOS level to
be able to operate: in your autoexec.bat you will have to set the
following variables:

- DLC: This environment variable is used by Intersolv to point to the
startup.pf and the progress.cfg files in the DLC directory where you
installed the Progress product on your PC. With the progress.cfg the
Intersolv ODBC driver will be able to check if you have the
capabilities to access a local database (needed for the æLocal OID
against a local database in single user modeÆconfiguration) and/or
the capabilities of the Client Networking to access a remote
database (needed for all the other ODBC configurations, especially
for a local OID that access a Local WIPC server running on your PC.)
If you donÆt have the DLC variable set at DOS level, add it into
your autoexec.bat (e.g. SET DLC=C:\DLC)

- PATH: This environment variable should contain the C:\DLC\BIN
directory. If this is not the case, you should add that into your
autoexec.bat (e.g. PATH=%PATH%;C:\DLC\BIN). This is not mandatory,
but will help avoid a lot of troubles when using the Intersolv ODBC
driver. If it is the first time you are using this product, please
set the PATH variable so that it contains the DLC\BIN directory.

- PROMSGS: This environment variable is not needed, but is very useful
useful. If a problem occurs while using the ODBC driver, then
Intersolv will access the PROMSGS file referenced by this variable
and display in a dialog box a Progress error message. If you donÆt
have the PROMSGS variable set at DOS level, add it into your
autoexec.bat (e.g. SET PROMSGS=C:\DLC\PROMSGS).


2. Settings on the remote machine for a remote Database, and OID/OIB
-----------------------------------------------------------------

Starting here, please remember that all environment settings are
specific to UNIX configurations. Please check your manuals for other
Operating Systems such as VMS or NT.


2.1. The Server
----------

To access to a remote database from ODBC you need to have a Progress
server running on that remote machine. That server needs its own
environment settings. Please Read "System Administration Guide" and
"Pocket Progress" manuals.


2.2. The OID
-------

The OID also needs some of the environment settings used by the server
These are:

- DLC: This variable is used by the OID to check the progress.cfg

- PATH: This variable has to contain the $DLC/bin directory, otherwise
the OID will not be started in the next part. (There should be a
script in that directory named 'prooidrv' that can be used to start
the OID.)

- PROOIDRV: You can also set this variable to $DLC/bin/_prooidv in
your UNIX environment or in the script used to start the OID. This
variable is not needed but it can be used to start the OID. Its
setting is highly recommended. (at the UNIX prompt type:
set PROOIDRV=$DLC/bin/_prooidv; export PROOIDRV)

To start the OID, please refer to the Kbase on 'How to start and stop
an OID or OIB under UNIX',or check the commands Prooidrv and Proshut
in your System administration manuals, or Embedded SQL Guide and
Reference, or your ODBC driver Guide.


2.3. THE OIB
-------

The OIB as well needs some of the environment settings used by the
server. But to be more precise, it needs:

- DLC: This variable is used by the OIB to check the progress.cfg

- PATH: This variable has to contain the $DLC/bin directory, otherwise
the OIB will not start. (There should be a script in that directory
named 'prooibrk' that can be used to start the OIB.)

- PROOIDRV: This variable is used by the OIB to spawn the OID.
Consequently this variable is NEEDED and has to be set to
$DLC/bin/_prooidv and then exported. (at the UNIX prompt type:
set PROOIDRV=$DLC/bin/_prooidv; export PROOIDRV)

- PROOIBRK: You can also set this variable to $DLC/bin/_prooibk in
your UNIX environment or in the script used to start the OIB. This
variable is not needed but it can be used to start the OIB. Its
setting is highly recommended. (at the UNIX prompt type:
set PROOIBRK=$DLC/bin/_prooibk; export PROOIBRK)

To start the OID, please refer to the Kbase on 'How to start and stop
an OID or OIB under UNIX',or check the commands Prooidrv and Proshut
in your System administration manuals, or Embedded SQL Guide and
Reference, or your ODBC driver Guide.


Sebastien HAEFELE
(March, 6. 1997)

Progress Software Technical Support Note # 16725