ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Native Connectors/Native Accesses / Native MariaDB Connector
  • Overview
  • Required configuration
  • Conditions for Native MariaDB Connectors
  • Required files
  • Installing a new version of MariaDB
  • Files required to use Native MariaDB Connector in Linux
  • Use
  • Using Native MariaDB Connector in your WINDEV applications and WEBDEV sites
  • Optimizing HFSQL functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
WINDEV and WEBDEV 2024 include a Native MariaDB Connector (also called Native MariaDB Access). This Native Connector allows you to access a MariaDB database from a WLanguage program without using any external driver.
Caution: This version of the Native MariaDB Connector works with WINDEV and WEBDEV version 2024.
Remark: The Native MariaDB Connector is an optional and free module available for download from the PC SOFT site
Required configuration
WINDEVWEBDEV - Server codeWindowsNative Connectors (Native Accesses)

Conditions for Native MariaDB Connectors

  • WINDEV or WEBDEV 2024.
  • MariaDB client library (libmariadb.DLL file)
    • 32-bit client library to use the 32-bit Native MariaDB Connector (version 3.x.x to 10.x.x tested).
    • 64-bit client library to use the 64-bit Native MariaDB Connector (version 10.x.x tested).
  • The LibMariaDB.DLL DLL must be:
    • On the development computer:
      • in the "\Programs\Framework\Win32x86" directory of the installation directory of WINDEV or WEBDEV (32-bit).
      • in the "\Programs\Framework\Win64x86" directory of the installation directory of WINDEV or WEBDEV (64-bit).
    • 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.
WINDEVWEBDEV - Server codeWindowsNative Connectors (Native Accesses)

Required files

The following files are required to use Native MariaDB Connector:
  • The LibMariaDB.DLL DLL. This DLL is distributed with MariaDB. For more details, see the license of MariaDB 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 wd290maria.dll DLL: Required for the 64-bit Native Connector to a MariaDB database. This file is provided with the Native MariaDB Connector for WINDEV and/or WEBDEV.
  • The wd290maria64.dll DLL: Required for the 64-bit Native Connector to a MariaDB database. This file is provided with the 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 to the EXE subfolder of the 32-bit project configuration.
  • copy the 64-bit libmariadb DLL to the EXE subfolder of the 64-bit project configuration.
WINDEVWEBDEV - Server codeWindowsNative Connectors (Native Accesses)

Installing a new version of MariaDB

The dialog between Native MariaDB Connector and MariaDB uses 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.
WINDEVWEBDEV - Server codeNative Connectors (Native Accesses)

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 library on the server. Check whether the libmariadbclient.so DLL was copied to /usr/lib.
Remark:
  • The 32-bit MariaDB client library must be installed to use the 32-bit Native MariaDB Connector.
  • The 64-bit MariaDB client library 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 line of code:
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:
  • wd290hf.so: HFSQL library
  • wd290maria.so: library of 32-bit native connector
  • wd290maria64.so: library of 64-bit native connector
  • wd290sql.so: SQL library
3. If you are using a Linux batch application, copy the following DLLs into the application directory:
  • wd290hf.so: HFSQL library
  • wd290maria.so: library of 32-bit native connector
  • wd290maria64.so: library of 64-bit native connector
  • wd290sql.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:
Remarks:

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).
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/07/2023

Send a report | Local help