Native Progress Connector for WINDEV and WEBDEV

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / Native Connectors/Native Accesses / Native Progress Connector

Overview
Required configuration
Native Progress Connector requirements
Required files
Connection to a Progress database
Use
Using a Native Progress Connector in WINDEV applications or WEBDEV websites

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Native Progress Connector for WINDEV and WEBDEV

Available only with this kind of connection

Overview

WINDEV and WEBDEV offer an optional Native Progress Connector (or "Native Access to Progress"). This Native Connector allows you to access a Progress database from a WLanguage program.

Attention: This version of the Progress Native Connector only works with WINDEV or WEBDEV 2025. This Native Connector is only available in 32 bits.

Required configuration

Native Progress Connector requirements

Progress Version 7.3 C (or later) on the server (tests have been run with Progress version 9.1D)
Progress client on each machine accessing Progress (minimum version: 8.2A).
The Progress client version 11 is supported.

Required files

The following files are required to use a Native Progress Connector:

the Progress client DLL. This DLL is installed by the client library of Progress. For more details, see the license agreement of Progress about the distribution conditions of this DLL.
wd300prgs.dll: Necessary for the Native Connector to a Progress base.. This file is provided with the Native Progress Connector.

Connection to a Progress database

The Native Connector uses the Progress client library to connect to the server.

The DLL used by the Native Connector can correspond to the ODBC driver used to access Progress. The name of this DLL can change according to the Progress versions. The following checks must be performed in order to define the DLL to load:

1. Checking the extended information of the connection.
If the name of the DLL is specified in the extended information of the connection (WD CLIENT LIBRARY parameter), this DLL is loaded.
Example: "WD CLIENT LIBRARY= C:\Program Files (x86)\Progress\OpenEdge\bin\pgoe1023.dll"

Example: Connection to a Progress database, specifying the client library layer to be used and the port:

// Définition d'une variable de type Connexion
// Au mieux: utilisation du nom de la connexion définie dans l'analyse 
// (dans ce cas ne pas déclarer la variable ici)
cnxProgress is Connection 

// Nom du serveur Progress
cnxProgress.Serveur = "NomServeurProgress"
// Nom de la base de données
cnxProgress.BaseDeDonnées = "Base"
// Utilisateur de la base
cnxProgress.Utilisateur = "utilisateur"
// Mot de passe de la base
cnxProgress.MotDePasse = "MDP"
// Connecteur Natif Progress
cnxProgress.Provider = hNativeAccessProgress
// Informations étendues pour préciser le port et l'emplacement de la couche client Progress
cnxProgress.InfosEtendues = "PORT=25000;WD CLIENT LIBRARY=" + ...
	"C:\Program Files (x86)\Progress\OpenEdge\bin\pgoe1023.dll"
// Test de la connexion à la base
IF NOT HOpenConnection(cnxProgress) THEN
	Error("Echec de la connexion à la base", HErrorInfo())
	EndProgram()
END

2. Checking the ODBC data source.
The name of the data source corresponds to an ODBC data source defined on the runtime computer. In this case, the Native Connector uses the ODBC driver of the ODBC data source.

3. Solution retained for compatibility with previous versions: search for file "WDPRGS.INI "
The Windows directory contains a "WDPRGS.INI" file that includes the following information:

[CLIENT]
DRIVER = <Nom de la DLL>

where <DLL Name> corresponds to the full path of the Progress DLL. This DLL can also correspond to the ODBC driver used to access Progress.

Example of WDPRGS.INI file:

[CLIENT]
DRIVER = C:\program Files\PROGRESS\bin\pgpro915.dll

4. If no DLL was loaded during the previous steps, the Native Connector tries to load the PGPRO915.DLL DLL.

Note: It is generally necessary to add the Progress client library directory to the machine's PATH (for example: C:\Program Files\PROGRESS\bin).

Use

Using a Native Progress Connector in WINDEV applications or WEBDEV websites

To use the Native Progress Connector, you must program:

with the "SQL" functions of WLanguage (see Programming with SQL functions).
with the "HFSQL" functions of WLanguage (see Programming with HFSQL functions).

Remark: Don't forget to consult the limitations of the Native Progress Connector.