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

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
multi-insert get error.
Error of multiple statements: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ...
multi-insert get error.
Error of multiple statements: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ...
Make sure you have set multi statement client flag on database connection opening.
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.
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) ?
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.