AYUDA EN LÍNEA
 WINDEV, WEBDEV Y WINDEV MOBILE
Este contenido se ha traducido automáticamente.  Haga clic aquí  para ver la versión en inglés.
Ayuda / Conectores Nativos/Accesos Nativos / Conector Nativo MySQL
  • Overview
  • Required configuration
  • Native MySQL Connector requirements
  • Required files
  • Installing a new version of MySQL
  • Files required to use Native MySQL Connector in Linux
  • Use
  • Using the Native MySQL Connector in your WINDEV applications and WEBDEV websites
  • Optimizing HFSQL functions
WINDEV
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
Overview
WINDEV and WEBDEV 2025 propose a Native MySQL Connector (or Native MySQL Access). This Native Connector allows you to access a MySQL database from a WLanguage program without using any external driver.
Attention This version of the MySQL Native Connector only works with WINDEV and WEBDEV version 2025. The Native MySQL Connector is not available for WINDEV Mobile. If you are using WINDEV Mobile, the access to a foreign database (MySQL, Oracle, SQL Server) must be performed via a Web service provided with WINDEV Mobile. For more details, see the help about SQLConnectWS.
Note The MySQL Native Connector is a free optional module available for download at the PC SOFT site
Required configuration
WINDEVWindowsConectores Nativos

Native MySQL Connector requirements

  • Client library of MySQL (LibMySQL.DLL file)
    • 32-bit Client Library to use the 32-bit MySQL Native Connector (version 5.x tested).
    • 64-bit Client Library to use the 64-bit MySQL Native Connector (version 5.5 and 8.0 tested).
  • The LibMySQL.DLL DLL must be found:
    • 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.
WINDEVWindowsConectores Nativos

Required files

The following files are required to use the Native MySQL Connector:
  • The LibMySQL.DLL DLL. This DLL is distributed with MySQL. For more details, see the license agreement of MySQL about the distribution conditions of this DLL.
    • 32-bit file to use the 32-bit Native MySQL Connector.
    • 64-bit file to use the 64-bit Native MySQL Connector.
    From version 5.5 of libmysql.dll client, the computer that runs the application must install a Visual Studio Redistributable package corresponding to the server version (for more details, see the Oracle site).
  • The DLL wd300msql.dll required for the 32-bit Native Connector to a MySQL database. This file is supplied with the Native MySQL Connector for WINDEV or WEBDEV.
  • The DLL wd300msql64.dll required for the 64-bit Native Connector to a MySQL database. This file is supplied with the Native MySQL Connector for WINDEV or WEBDEV.
To debug a multi-configuration project in 32-bit and 64-bit configuration:
  • copy the 32-bit libmysql DLL into the EXE sub-folder of 32-bit configuration of project.
  • copy the 64-bit libmysql DLL into the EXE sub-folder of 64-bit configuration of project.
WINDEVWindowsConectores Nativos

Installing a new version of MySQL

The dialog between the Native MySQL Connector and MySQL uses the LIBMYSQL.DLL library provided with MySQL.
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 LIBMYSQL.DLL. This DLL will operate with the new version of MySQL, while still being compatible with the Native Connector.
WINDEVLinuxConectores Nativos

Files required to use Native MySQL Connector in Linux

To use Native MySQL Connector in Linux, the following operations must be performed:
  1. Install the MySQL client library on the server. Check whether the libmysqlclient.so DLL was copied into /usr/lib.
    Remarks:
    • The 32-bit MySQL client library must be installed to use the 32-bit Native MySQL Connector.
    • The 64-bit MySQL client library must be installed to use the 64-bit Native MySQL Connector.
    If the copied DLLs are such as libmysqlClient.so.12.0.0, a link must be created on this DLL with the following line of code:
    ln -s libmysqlclient.so.12.0.0 libmysqlclient.so
  2. If you're using a WEBDEV site, copy the following DLLs into the WEBDEV Application Server directory:
    • wd300hf.so: HFSQL library
    • wd300msql.so: 32-bit Native Connector library
    • wd300msql64.so: 64-bit Native Connector library
    • wd300sql.so: SQL library
  3. If you are using a Java application or a Linux Batch, copy the following DLLs to the application directory:
    • wd300hf.so: HFSQL library
    • wd300msql.so: 32-bit Native Connector library
    • wd300msql64.so: 64-bit Native Connector library
    • wd300sql.so: SQL library
Use

Using the Native MySQL Connector in your WINDEV applications and WEBDEV websites

To use MySQL in native mode, you must program in the WINDEV application or WEBDEV website:
Remarks:
  • Don't forget to read the limitations of the Native MySQL Connector.
  • The "Crear automáticamente los archivos de datos al abrirlos" option (available in the "Data files" tab of the project description) is taken into account by the MySQL Native Connector.

Optimizing HFSQL functions

  • Query-based data-bound Table control fields are optimized. You can sort the contents of a Table control by clicking on 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).
Ver también
Versión mínima requerida
  • Versión 9
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 26/06/2025

Señalar un error o enviar una sugerencia | Ayuda local