Native MariaDB Connector for WINDEV and WEBDEV

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

Overview

Required configuration

Use

See also

Native MariaDB Connector for WINDEV and WEBDEV

Available only with this kind of connection

Overview

WINDEV and WEBDEV 25 propose a Native Connector to MariaDB (also called module for Native Access). This Native Connector allows you to access a MariaDB database from a WLanguage program without using any external driver.

Caution: This version of Native MariaDB Connector operates with WINDEV and WEBDEV version 25.

Remark: The Native MariaDB Connector is an optional and free module available for download from the PC SOFT site

Required configuration

Conditions for using Native MariaDB Connector

Client layer of MariaDB (libmariadb.DLL file)
- 32-bit client layer to use the 32-bit Native MariaDB Connector (version 2.x checked).
- 64-bit client layer to use the 64-bit Native MariaDB Connector (version 2.x checked).
The LibMariaDB.DLL DLL must be found:
- On the development computer:
  - in the "\Programs\Framework\Win32x86" directory of the setup directory of WINDEV or WEBDEV (32 bits).
  - in the "\Programs\Framework\Win64x86" directory of the setup directory of WINDEV or WEBDEV (64 bits).
- On the deployment computer, in the executable directory or in the Windows directory. For a deployment on a Web server, the DLL must be found in the directory of the Native Connector or in the Windows directory.

The necessary files

The following files are required to use Native MariaDB Connector:

The LibMariaDB.DLL DLL. This DLL is supplied with MariaDB. See the license of MariaDB for more details about the distribution conditions of this DLL.
- 32-bit file to use the 32-bit Native MariaDB Connector.
- 64-bit file to use the 64-bit Native MariaDB Connector.
The wdxxxmaria.dll DLL: Required for the 64-bit Native Connector to a MariaDB database. This file is supplied with Native MariaDB Connector for WINDEV and/or WEBDEV.
The wdxxxmaria64.dll DLL: Required for the 64-bit Native Connector to a MariaDB database. This file is supplied with Native MariaDB Connector for WINDEV and/or WEBDEV.

To debug a multi-configuration project in 32-bit and 64-bit configuration:

copy the 32-bit libmariadb DLL into the EXE sub-folder of 32-bit project configuration.
copy the 64-bit libmariadb DLL into the EXE sub-folder of 64-bit project configuration.

Installing a new version of MariaDB

The dialog between Native MariaDB Connector and MariaDB is using the LibMariaDB.DLL DLL supplied with MariaDB.
The Native Connector may no longer operate if the behavior of this DLL is modified (when changing version for example).

An upgraded version that takes these changes into account will be available soon ; meanwhile, all you have to do is use the previous version of LibMariaDB.DLL. This DLL will operate with the new version of MariaDB, while still being compatible with the Native Connector.

Files required to use Native MariaDB Connector in Linux

To use Native MariaDB Connector in Linux, the following operations must be performed:

1. Install the MariaDB client layer on the server. Check whether the libmariadbclient.so DLL was copied into /usr/lib.

Remark:

The 32-bit MariaDB client layer must be installed to use the 32-bit Native MariaDB Connector.
The 64-bit MariaDB client layer must be installed to use the 64-bit Native MariaDB Connector. If the copied DLLs are such as libmariadbClient.so.12.0.0, a link must be created on this DLL via the following code line:

ln -s libmariadbclient.so.12.0.0 libmariadbclient.so

2. If you are using a WEBDEV site, copy the following DLLs into the directory of WEBDEV application server:

wd250hf.so: HFSQL library
wd250maria.so: library of 32-bit native connector
wd250maria64.so: library of 64-bit native connector
wd250sql.so: SQL library

3. If you are using a Linux batch application, copy the following DLLs into the application directory:

wd250hf.so: HFSQL library
wd250maria.so: library of 32-bit native connector
wd250maria64.so: library of 64-bit native connector
wd250sql.so: SQL library

Use

Using Native MariaDB Connector in your WINDEV applications and WEBDEV sites

To use Native MariaDB Connector, 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).

Remarks:

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

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Optimizing HFSQL functions

The "Browsing table" controls based on queries are optimized: the content of the Table control can be sorted by clicking one of its columns.
To avoid re-running the same query several times when browsing its result, we advise you to use the hNoRefresh constant (if the data is modified by a single computer for example).