Native PostgreSQL Connector for WINDEV and WEBDEV

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

Native Connectors/Native Accesses

Native PostgreSQL Connector

Native PostgreSQL Connector for WINDEV and WEBDEV

Overview

Required configuration

Use

See also

Native PostgreSQL Connector for WINDEV and WEBDEV

Available only with this kind of connection

Overview

WINDEV and WEBDEV 23 propose a Native Connector to PostgreSQL (also called native access to PostgreSQL), available in 32 and 64 bits. This Native Connector allows you to access a PostgreSQL database from a WLanguage program without using any external driver.

Versions 20 and later
The Native Connector to PostgreSQL is now available in 64 bits.

New in version 20
The Native Connector to PostgreSQL is now available in 64 bits.

The Native Connector to PostgreSQL is now available in 64 bits.

Caution: This version of Native PostgreSQL Connector operates with WINDEV and WEBDEV version 23.

Note: The Native PostgreSQL Connector is an optional and free module that can be downloaded from the PC SOFT site.

Required configuration

Conditions for using Native PostgreSQL Connector

The Libpq.DLL DLL is requird by Native PostgreSQL Connector. This DLL is supplied with Native PostgreSQL Connector. It was re-compiled from the sources of PostgreSQL version 7.4.23 to be compatible will all versions of Windows from Windows 98. It contains all the features required by the Native Connector and it is compatible with the most recent servers (8.3.6).

The Libpq.DLL DLL must be found:

On the development computer, in the setup directory of WINDEV and/or WEBDEV.
On the deployment computer, in the executable directory or in the Windows directory.

Note: The Libpq.dll file can be replaced by a more recent version. Make sure that you also copy/install all dependencies of this DLL.

For example, to use the libpq.dll of PostgreSQL version 8.3.6, you must:

Copy the DLLs of the PostgreSQL client layer into the same directory. These DLLs are as follows: ssleay32.dll, libpq.dll, libeay32.dll, libintl3.dll, libiconv2.dll, krb5_32.dll, comerr32.dll, k5sprt32.dll, gssapi32.dll
Install the DLLs of Visual 2005 SP2 runtime (package that can be downloaded from Microsoft Web site).

We recommend that you use a recent PostgreSQL client layer, whose version is identical to the version of your server if possible.

To do so, you must:

Copy the DLLs of PostgreSQL client layer into the setup directory of WINDEV or WEBDEV on the development computer.
Copy the DLLs of PostgreSQL client layer into the executable directory or into the Windows directory on the development computer.
Install the DLLs of Visual runtime (package that can be downloaded from Microsoft site).
Note: The version of visual runtime depends of PostgreSQL client layer.

In 32 bits, if these DLLs are not found, the Native PostgreSQL Connector will be using a standard client layer corresponding to the version 7.4.23 of PostgreSQL. It contains all features required by the Native Access and it is compatible with the most recent servers (8.3.6).

Note: To use the SSL connections, you must install a PostgreSQL client layer version 9.1 or later.

The necessary files

The following files are required to use Native PostgreSQL Connector:

The Libpq.DLL DLL. This file is supplied Native PostgreSQL Connector for WINDEV and WEBDEV.
The wdxxxpostgresql.DLL DLL: Required for the native access to a PostgreSQL database. This file is supplied Native PostgreSQL Connector for WINDEV and WEBDEV.

Specific file

To use Native PostgreSQL Connector, only the wdxxxpostgresql.DLL DLL is required. This file is supplied Native PostgreSQL Connector for WINDEV and WEBDEV.

Specific file supplied with Native PostgreSQL Connector

To use Native PostgreSQL Connector:

in 32 bits, only the wdxxxpostgresql.DLL DLL is required. This file is supplied Native PostgreSQL Connector for WINDEV and WEBDEV.
Versions 20 and later
in 64 bits, only the wdxxxpostgresql64.DLL DLL is required. This file is supplied Native PostgreSQL Connector for WINDEV and WEBDEV.
New in version 20
in 64 bits, only the wdxxxpostgresql64.DLL DLL is required. This file is supplied Native PostgreSQL Connector for WINDEV and WEBDEV.
in 64 bits, only the wdxxxpostgresql64.DLL DLL is required. This file is supplied Native PostgreSQL Connector for WINDEV and WEBDEV.

Use

Using Native PostgreSQL Connector in your WINDEV applications and WEBDEV sites

To use PostgreSQL in native mode, you must program in the WINDEV application or in the WEBDEV site:

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

Notes:

Don't forget to read limitations regarding the use of Native PostgreSQL Connector.
Versions 23 and later
The option "Automatically create the data files if they do not exist" (found in the "Files" tab of project description) is taken into account by Native PostgreSQL Connector.
New in version 23
The option "Automatically create the data files if they do not exist" (found in the "Files" tab of project description) is taken into account by Native PostgreSQL Connector.
The option "Automatically create the data files if they do not exist" (found in the "Files" tab of project description) is taken into account by Native PostgreSQL Connector.