Discussion of article "How to Access the MySQL Database from MQL5 (MQL4)" - page 22

[Valentin Dobroletov]

has anyone converted to UTF-8 ?

[Shorttimer]

Great library. Too bad it doesn't support Cyrillic alphabet.

[trader4321]

phlixetrader:

I resolved some problems with 64bit Windows (7) by creating an x64 configuration in Visual Studio 2017. (And finding latest mysql libraries).

Can I suggest to the author, maybe putting the source on github, then it can be maintained there by the community.

With thanks to Eugeniy Lugovoy for a first class piece of software :)

Hi,

Could you help us with your solution? I'm struggling to solve this issue, but I have 0 experience with c++ and VS.

Thank you.

[Tufan Kose]

Eugeniy Lugovoy, you are wonderful. Thank you for sharing the 64 bit version of MQLMySQL.dll.

[Rui Pedro Goncalves Da Cruz Moreira Da Silva]

Alnamri Alnamri:

i have same problem

"Cannot load 'C:\Users\Admin\AppData\Roaming\MetaQuotes\Tester\D0E8209F77C8CF37AD8BF550E51FF075\Agent-127.0.0.1-3000\MQL5\libraries\MQLMySQL.dll'"

"Cannot call 'cMySqlVersion', '..\libraries\MQLMySQL.dll' is not loaded"

"unresolved import function call"

i am waiting your help.........

Hi Alnamri,
I don't know if you still have this problem or not, but I solved it by changing the:

#import "..\libraries\MQLMySQL.dll"
to
#import "..\Libraries\MQLMySQL.dll"

(The "\libraries\MQLMySQL.dll' is not loaded" error only appeared in the Strategy Tester)

This library works great, thanks to the programmer.

[Alejandro FG]

Hello for resolve the mistake:

"Cannot load 'C:\Users\Admin\AppData\Roaming\MetaQuotes\Tester\D0E8209F77C8CF37AD8BF550E51FF075\Agent-127.0.0.1-3000\MQL5\libraries\MQLMySQL.dll'"

"Cannot call 'cMySqlVersion', '..\libraries\MQLMySQL.dll' is not loaded"

"unresolved import function call"

You have to open the project from visual studio and re-compile everything and add DLL in to MT5 or MT4 again.

Work x64:

2019.12.27 17:26:05.437 MySQL-001 (EURUSD,M1) MQLMySQL v2.2 x64 Copyright © 2014, FxCodex Laboratory

2019.12.27 17:26:05.438 MySQL-001 (EURUSD,M1) Host: , User: , Database: 

2019.12.27 17:26:05.438 MySQL-001 (EURUSD,M1) Connecting...

2019.12.27 17:26:07.458 MySQL-001 (EURUSD,M1) Connected! DBID#0

2019.12.27 17:26:09.460 MySQL-001 (EURUSD,M1) Connected! DBID#1

2019.12.27 17:26:11.463 MySQL-001 (EURUSD,M1) Connected! DBID#2

2019.12.27 17:26:11.463 MySQL-001 (EURUSD,M1) All connections closed. Script done!

[Eugeniy Lugovoy]

Hi all.

I've rebuilt DLLs and MQL libraries (of MQLMySQL) to support unicode, now reviewing all sources and will share on GitHub very soon.

Also I'm testing now MQLAdoDB project to work with different databases (MS SQL, Oracle, PostgreSQL, MS Access, etc) from MQL using AdoDB & OLEDB.

This project also would be available soon on GitHub, and of course it would be free.

Best regards,

Eugene

[Alejandro FG]

[Eugeniy Lugovoy]

The MQLMySQL library version 3.0 is released and published on GitHub: https://github.com/elugovoy/MQLMySQL-Project

Any further fixes & updates would be made in GitHub repository.

Codepage UTF-8 is supported now.

Project keeps 3 directories for:

- MQL4 x86 - function set

- MQL5 x64 (old school) - function set

- MQL5 x64 (classes) - classes for MQL5

<Deleted>

Happy New Year & good luck in development!

Eugene

[Eugeniy Lugovoy]

The MQLMySQL library version 3.0 has been released and published on GitHub: https://github.com/elugovoy/MQLMySQL-Project.

Any further fixes and updates will be made to the GitHub repository.

UTF-8 code page is now supported.

The project contains 3 catalogues for:

- MQL4 x86 - set of functions

- MQL5 x64 (old school) - a set of functions

- MQL5 x64 (classes) - classes for MQL5.

All details in README.md