PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WEBDEV 2024 → MySQL access problem
MySQL access problem
Iniciado por Giz, 29,abr. 2016 16:33 - 1 respuesta
Publicado el 29,abril 2016 - 16:33
Hi,

I have installed the pre-release WebDev 21 in my system. I use an existing MySQL database. I am able to get the database tables to create the data files for analysis. The problem arises when I test my page. I get the following error.

What happened?
The 'TABLE_Login' control was not be initialized, the following HFSQL error occurred:
=============================
native MySQL access error.
Error Number = 27

The MySQL client layer may not be installed properly.
No access library to MySQL was found, the libmysql.dll module (32 bits) or one of its dependencies has not been loaded.
The MySQL client layer must be found in a directory declared in PATH.
=============================

Error code: 310085
Level: fatal error
WD55 error code: 3001

System error code: 193
System error message:
libmysql.dll
Dump of the error of 'wd210page.dll' module (21.0.104.2).
Identifier of detailed information (.err): 310085
Debugging information:
IEWDMSQL=9.1
Module=<WDMSQL>
Version=<21.0.8.0>
Additional Information:
EIT_NATIVECODE : <27>
EIT_LOGICALTABLENAME : <Login>

(25, ERR_MSG_BOX)

%1 is not a valid Win32 application. (193)

I have put mySQL in the path, I have also copied libmysql.dll to the exe folder of the application and also webdev Programs folder. I have downloaded and installed the native access to mysql for webdev 21 provided by pc soft. I do not understand where am I going wrong. The MySQL version is 5.7
Publicado el 19,mayo 2016 - 15:51
HI,
I had the same problem, I installed 64-bit, so I installed the MySQL Connector 64bit, problem solved