PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Required configuration
  • Conditions for using Native MariaDB Connector
  • The necessary 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
WINDEV and WEBDEV 23 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 23.
Note: The Native MariaDB Connector is an optional and free module available for download from the PC SOFT site
Required configuration
WINDEVWEBDEV - Server codeWindowsNative Accesses

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 setup directory of WINDEV and/or WEBDEV.
    • On the deployment computer, in the executable directory or in the Windows directory.
WINDEVWEBDEV - Server codeWindowsNative Accesses

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 32-bit native access 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 access 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.
WINDEVWEBDEV - Server codeWindowsNative Accesses

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.
WINDEVWEBDEV - Server codeLinuxNative 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 layer on the server. Check whether the libmariadbclient.so DLL was copied into /usr/lib.
Note:
  • 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:
  • wd230hf.so: HFSQL library
  • wd230maria.so: library of 32-bit native connector
  • wd230maria64.so: library of 64-bit native connector
  • wd230sql.so: SQL library
3. If you are using a Linux batch application, copy the following DLLs into the application directory:
  • wd230hf.so: HFSQL library
  • wd230maria.so: library of 32-bit native connector
  • wd230maria64.so: library of 64-bit native connector
  • wd230sql.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:
Notes:
  • 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 if they do not exist" (found in the "Files" tab of project description) is taken into account by Native MariaDB 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 MariaDB 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 MariaDB Connector.
Note: 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).
Minimum required version
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment