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

[Alnamri Alnamri]

GreenKobra:

Hi I have loaded dll in Libraries folder but it report an error " "Cnnot call 'cMySqlVersion', '....\Libraries\MQLMySQL.dll' is not loaded

How is it possible?

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.........

[[Deleted]]

help me connect my real account proxy server including ip number sequence to amegafx.com .

   thanks 

paul 

after i shifted something on my firewall no go .!!

[Egor]

Greetings everyone.

I am just starting to learn MQL4.

I have a problem. The script crashes and curses

0 19:53:51.456 MySQL-003 EURUSD,Monthly: initialised

1 19:53:51.456 Cannot call '..\libraries\MQLMySQL.dll::cMySqlVersion', DLL is not allowed

1 19:53:51.456 MySQL-003 EURUSD,Monthly: unresolved import function call

0 19:53:51.456 MySQL-003 EURUSD,Monthly: uninit reason 0

0 19:53:51.464 Script MySQL-003 EURUSD,Monthly: removed

I understand that the problem lies here? -> 1 19:53:51.456 Cannot call '..\libraries\MQLMySQL.dll::cMySqlVersion', DLL is not allowed.

What can be the problem, please tell me.

The files are placed as follows:

..\include\MQLMySQL.mqh

..\libraries\libmysql.dll MQLMySQL MQLMySQL.dll

..\scripts\MyConnection.ini MySQL-00*.mq4

OS Windows 10 x64

[Sergey Kolemanov]

starticys:

119:53:51.456Cannot call '..\libraries\MQLMySQL.dll::cMySqlVersion', DLL is not allowed

First of all, check if DLL import is allowed: Service - Settings - Advisors, the corresponding line should be ticked.

[Egor]

Sergey Kolemanov:

First of all, check if DLL import is allowed : Service - Settings - Expert Advisors, in the corresponding line there should be a tick.

Thank you. I went on suffering)

[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 :)

[procomK]

Dear experts, please advise me.
32-bit permvar2.dll (from MessageBoxW(uint hWnd,string lpText,string lpCaption,uint uType);

int PVInit(string);
int PVValue(int,string,int);
int PVGetValue(int,string);

Compiles, but gives error :
'C:\Program Files\ForexClub MT5\MQL5\Libraries\permvar2.dll' is not 64-bit version
Cannot load 'C:\Program Files\ForexClub MT5\MQL5\Libraries\permvar2.dll' [193]

If calling permvar.dll
#import "stdlib.ex5"
#import "permvar.dll"

Message :
unresolved import function call

Can it be initiated differently ?

[WembleyFraggle]

Hi moose2089,

in  MQLMySQL.mqh replace "StrToInteger" with "StringToInteger" and "StrToDouble" with "StringToDouble" and it will work.

Best regards

moose2089:

Hi  Eugeniy Lugovoy 

I'm getting the following error not sure what is up!

The errors occurs on the MQLMySQL.mqh file

'StrToInteger' - function not defined MQLMySQL.mqh 224 10

'StrToDouble' - function not defined MQLMySQL.mqh 229 10

on the following lines of code:

int MySqlGetFieldAsInt(int pCursorID, int pField)

{

 return (StrToInteger(MySqlGetRowField(pCursorID, pField)));

}

double MySqlGetFieldAsDouble(int pCursorID, int pField)

{

 return (StrToDouble(MySqlGetRowField(pCursorID, pField)));

}

Kind Regards,

[PivotSquare]

Hi,

I've searched the forum here and all articles I find are already several years old.

I'm looking for a solution to publish MT4 and MT5 trades information (open, pending and closed) to a website (via MySQL database). Trade information published should follow the possibilities offered by MyFxBook.com for instance, including magic number. The solution should be able to differentiate different users of the website (i.e. through an authentication method like user name and password) - this means a user of the website is only able to publish date in his own area of the website.

I'm willing to pay for an already existing robust solution available that works in MT4 and MT5 but I can also consider to pay for developed solution in case there's none available.

Any help or hints is greatly appreciated.Please Personal Message if you want to propose yourself to supply this solution commercially.

Note: I'm not a coder so no need to direct me to threads of people discussing the nitty gritty of the technical solution itself.

Thank you!

[Kareem Abdelhakim]

PivotSquare:

Hi,

I've searched the forum here and all articles I find are already several years old.

I'm looking for a solution to publish MT4 and MT5 trades information (open, pending and closed) to a website (via MySQL database). Trade information published should follow the possibilities offered by MyFxBook.com for instance, including magic number. The solution should be able to differentiate different users of the website (i.e. through an authentication method like user name and password) - this means a user of the website is only able to publish date in his own area of the website.

I'm willing to pay for an already existing robust solution available that works in MT4 and MT5 but I can also consider to pay for developed solution in case there's none available.

Any help or hints is greatly appreciated.Please Personal Message if you want to propose yourself to supply this solution commercially.

Note: I'm not a coder so no need to direct me to threads of people discussing the nitty gritty of the technical solution itself.

Thank you!

It's as simple as that you just need to export your trades to MySQL DB  , and of course you need hosting provider like HostGator , GoDaddy or something similar that will host your website and the database . Finally from your website you need to connect to MySQL DB and show information on your website . This requires PHP or any back-end language like nodejs or whatever  language this is to manage useres and connect with DB .  And of course front-end for the visualization and appearance of website