 |
 Warning: Content of this document will be soon extended.
This page is also available for: WINDEV, WEBDEV
| Displayed version: |
|
| | Native PostgreSQL Access for WinDev and WebDev | |
Overview | | WinDev and WebDev 18 propose a module for native access to PostgreSQL. This Native Access enables you to access a PostgreSQL database from a WLanguage program without using an external driver. Caution: This version of the Native PostgreSQL Access operates with WinDev and WebDev version 18. Note: The Native PostgreSQL Access is an optional and free module available for download from the PC SOFT site |
|
New feature of this version 18 |  Versions 18 and laterSSL certificatesThe Native PostgreSQL Access supports the connections that use SSL certificates. See Connections with SSL certificates for more details.  New in version 18SSL certificatesThe Native PostgreSQL Access supports the connections that use SSL certificates. See Connections with SSL certificates for more details.
The Native PostgreSQL Access supports the connections that use SSL certificates. See Connections with SSL certificates for more details. |
|
Required configuration | Conditions for using the Native PostgreSQL AccessThe Native PostgreSQL Access requires the Libpq.DLL DLL. This DLL is supplied with the Native PostgreSQL Access. It was re-compiled from the sources of PostgreSQL version 7.4.23 to be compatible will all the versions of Windows from Windows 98. It contains all the features required by the Native Access 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/WebDev.
- On the deployment computer, in the directory of the executable or in the directory of Windows.
Note: The Libpq.dll file can be replaced by a more recent version. Make sure that you also copy/install all the 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).
Conditions for using the Native PostgreSQL AccessThe version of the postgreSQL client layer and the version of your server should be identical.To do so, you must: - Copy the DLLs found in the PostgreSQL client layer into the setup directory of WinDev/WebDev on the development computer.
- Copy the DLLs found in the PostgreSQL client layer into the executable directory or into the Windows directory on the development computer.
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).
If these DLLs are not found, the Native PostgreSQL Access will be using a standard client layer corresponding to the version 7.4.23 of PostgreSQL. It contains all the 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 filesThe files required for using the Native PostgreSQL Access are as follows:- Libpq.DLL. This file is supplied with the Native PostgreSQL Access.
- wdxxxpostgresql.DLL: Required for the native access to a PostgreSQL database. This file is supplied with the Native PostgreSQL Access.
Necessary fileTo use the Native PostgreSQL Access, only wdxxxpostgresql.DLL is required. This file is supplied with the Native PostgreSQL Access. |
|
Use | | Using the Native PostgreSQL Access in your WinDev applications and in your WebDev sitesTo use PostgreSQL in native mode, you must program in the WinDev application or in the WebDev site:Note: Don't forget to read the limitations regarding the Native PostgreSQL Access. |
|
| | | |
| |
|
Minimum required version: 14
Community: 0 annotation   Please login to annotate | Terms of service
| |
| |
| | | |