PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → [WINDEV 22] Error 70181 Native MySQL Access
[WINDEV 22] Error 70181 Native MySQL Access
Iniciado por Salvatore Parrinello, 17,oct. 2017 18:20 - 4 respuestas
Publicado el 17,octubre 2017 - 18:20
Hi,

I have a problem with the Native MySQL Access with WINDEV 22. The error returned by the application is "error number 70181" described next :

Error at line 43 of Click BTN_CONNESSIONE process.
HReadFirst function called.
Type defined for <anagrafiche> file is unknown.

----- Technical Information -----

Project : General Test

WL call:
Process of 'Click BTN_CONNESSIONE' (WIN_DATABASE_FUNCTION_NATIVE.BTN_CONNESSIONE), line 43, thread 0
'HReadFirst' function, syntax 3

What happened?
Type defined for <anagrafiche> file is unknown.

Error code: 70181
Level: fatal error
WD55 error code: 181

Dump of the error of 'wd220hf.dll' module (22.0.85.1).
Identifier of detailed information (.err): 72108
Debugging information:
IEWDHF=32.199
Module=<WDHF>
Version=<22.0.85.1>
Fonction (7,10)
Additional Information:
EIT_LOGICALTABLENAME : <anagrafiche>
EIT_PILEWL :
Click BTN_CONNESSIONE (WIN_DATABASE_FUNCTION_NATIVE.BTN_CONNESSIONE), line 43
EIT_DATEHEURE : 17/10/2017 18:13:36
EIT_TYPE_WDFILE : <2>
EIT_IDCODE : <18>

In the Development Environment this error is not returned while if i generate the executable and run it contrariwise yes.

Does anyone know how to help me? Thanks a lot.
Publicado el 18,octubre 2017 - 00:30
Hello Salvatore,

if it works in test/go mode and not with the exe, then it means that
there is a difference between the 2 cases.

As you are talking about a native access, the difference must be:
- either the native access dll (different version, absence)
- or the MySQL client dll (different version, absence)
- or the DB you are accessing (different information in the connexion
instruction)

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)

More information on http://www.fabriceharari.com


Le 10/17/2017 à 10:20 AM, Salvatore Parrinello a écrit :
Hi,

I have a problem with the Native MySQL Access with WINDEV 22. The error
returned by the application is "error number 70181" described next :

Error at line 43 of Click BTN_CONNESSIONE process.
HReadFirst function called.
Type defined for <anagrafiche> file is unknown.

----- Technical Information -----

Project : General Test

WL call:
Process of 'Click BTN_CONNESSIONE'
(WIN_DATABASE_FUNCTION_NATIVE.BTN_CONNESSIONE), line 43, thread 0
'HReadFirst' function, syntax 3

What happened?
Type defined for <anagrafiche> file is unknown.

Error code: 70181
Level: fatal error
WD55 error code: 181

Dump of the error of 'wd220hf.dll' module (22.0.85.1).
Identifier of detailed information (.err): 72108
Debugging information:
IEWDHF=32.199
Module=<WDHF>
Version=<22.0.85.1>
Fonction (7,10)
Additional Information:
EIT_LOGICALTABLENAME : <anagrafiche>
EIT_PILEWL :
Click BTN_CONNESSIONE (WIN_DATABASE_FUNCTION_NATIVE.BTN_CONNESSIONE),
line 43
EIT_DATEHEURE : 17/10/2017 18:13:36
EIT_TYPE_WDFILE : <2>
EIT_IDCODE : <18>

In the Development Environment this error is not returned while if i
generate the executable and run it contrariwise yes.

Does anyone know how to help me?  Thanks a lot.
Publicado el 18,octubre 2017 - 09:46
Hello,
i'm sure that the client layer of MySQL connection and the database described in the connection are the same.
I've put the libmysql.dll both in the system32 directory of windows and directly in the folder of the executable itself for security but the error came out again...
Publicado el 20,octubre 2017 - 11:18
Thanks, I solved the problem. The application was generated in stand-alone executable mode with built-in freamework (DLLs included in .exe without extraction). Now I've tried generating with freamwork included in .exe but self-extracted at the first startup of the application and I do not encounter any more problems. Perhaps in the first case I used did not all DLLs be included? Thanks again, cordial greetings.
Publicado el 20,octubre 2017 - 12:01
Hi Salvatore,

from the top of my head, native accesses are NOT supported when in stand
alone EXE, and there is a message saying so when you generate the exe.
There is a list of things not working in that mode available in the help.

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)

More information on http://www.fabriceharari.com


Le 10/20/2017 à 3:18 AM, Salvatore Parrinello a écrit :
Thanks, I solved the problem. The application was generated in
stand-alone executable mode with built-in freamework (DLLs included in
.exe without extraction). Now I've tried generating with freamwork
included in .exe but self-extracted at the first startup of the
application and I do not encounter any more problems. Perhaps in the
first case I used did not all DLLs be included? Thanks again, cordial
greetings.