Discussion of article "How to Access the MySQL Database from MQL5 (MQL4)" - page 25
You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
does it support modify sql command?
it supports DML, DDL, DCL commands of SQL and, of course, SELECT
Make sure you have MQLMySQL.dll & MQLMySQL.def files located in your folder "C:\Users\Admin\AppData\Roaming\MetaQuotes\Tester\D0E8209F77C8CF37AD8BF550E51FF075\Agent-127.0.0.1-3000\MQL5\libraries\"
As you can see if you are running MQL programs in Tester mode, the path to libs would be different (because of UAC)
I'm using the same dll and def files in the agents paths, but the [126] error persists. It wasn't a problem exclusive to the tester.
Hy is native only supported for now. does anyone really need sha2 support in this solution?
So your database server is not locally hosted or even under a vpn?
Suppose the database is a server of licences for sold Expert Advisors, which connect to it and shovel out the admission to work on a particular account, and may contain some additional information. As an option, of course.
Hello, Eugeniy!
I use MySql to store tick data. But i can write only 1000 rows. How can i remove this limit? Can you help me?
Hello, Eugeniy!
I use MySql to store tick data. But i can write only 1000 rows. How can i remove this limit? Can you help me?
There is no limits, please check your logic to store ticks. if you are uses multistatement mode, there are only limit for command buffer size, so you may split your queries by 100 commands and use transactions.
I'm using the same dll and def files in the agents paths, but the [126] error persists. It wasn't a problem exclusive to the tester.
Unfortunately I cannot reproduce this situation right now. but usually error 126 raises when dll cannot be loaded/found. Is it works fine in regular mode (not in tester) ?
Suppose the database is a server of licences for sold Expert Advisors, which connect to it and rake out the admission to work on a particular account, and may contain some additional information. As an option, of course.
In my opinion it is not an option, in this case it is better to go from the Expert Advisor http/https-request to the server, where you can configure web service, security rules and local database with licences. Web service will locally connect to the database to check licences. it can be put under vpn to strengthen protection and configure gate to filter out the same ddos attacks.... As an option, of course.
There is no limits, please check your logic to store ticks. if you are uses multistatement mode, there are only limit for command buffer size, so you may split your queries by 100 commands and use transactions.
Thanks for the answer.
Unfortunately I cannot reproduce this situation right now. but usually error 126 raises when dll cannot be loaded/found. Is it works fine in regular mode (not in tester) ?
It worked after I updated the version of OpenSSL. Thanks for listening.