Your program link under Mysql in the operating system Windows Server 2008 64bit R2 SP1 , DB values are not stable, often is equal to -1, how to solve, please, Sir? please tell me, Urgent need ! Paid services , contact me email:2393607300@qq.com (I use MQL4 EA )
Ok, I see you have wrote an expert advisor for this purposes, and it is written without recommendations I've posted in article.
So, let's move step by step:
1. The calling of " DB = cMySqlConnect(Host, User, Password, Database, Port, Socket, ClientFlag); " should be made inside OnInit() standard function instead of OnTick().
2. You are uses cMySqlConnect - it's imported function form DLL, you have to use MySqlConnect function instead of cMySqlConnect function !
3. You have to call MySqlDisconnect function inside OnDeinit() stundard function.
4. You have to check database connection identifier inside OnTick() standard function to be sure that connect was successful.
Finally it will looks like:
DB values are not stable, often is equal to -1
According to this method has been solved , thank you very much!
C_1982: Your program link under Mysql in the operating system Windows Server 2008 64bit R2 SP1 , DB values are not stable, often is equal to -1, how to solve, please, Sir? please tell me, Urgent need ! Paid services , contact me email:2393607300@qq.com (I use MQL4 EA )
MySQL database server disconnects automatically when no queries was sent during specified timeout (on server side), this is why you need to check connection with db and reconnect if needed.
是的，这是众所周知的问题，因为基本上使用的是 ASCII 编码。现在我正在开发 UTF 编码支持，以解决这个问题。
这对我来说效果很好......
有人能帮我通过调用存储过程插入数据吗？
正确的方法是什么？其他 SQLConnection 使用方法是这样定义参数 的：
command.Parameters.Add("@ID", SqlDbType.Int);
command.Parameters["@ID"].Value = customerID；
预先致谢。
汤姆
这对我来说效果很好......
有人能帮我通过调用存储过程插入数据吗？
正确的方法是什么？其他 SQLConnection 使用方法是这样定义参数的：
command.Parameters.Add("@ID", SqlDbType.Int);
command.Parameters["@ID"].Value = customerID；
预先致谢。
汤姆
只需使用以下命令即可：MySqlExecute(DB, "call YourProc("+(string)customerID+")")
不支持绑定变量
對於x64平台，使用下面的庫（附討論）
Ok, I see you have wrote an expert advisor for this purposes, and it is written without recommendations I've posted in article.
So, let's move step by step:
1. The calling of " DB = cMySqlConnect(Host, User, Password, Database, Port, Socket, ClientFlag); " should be made inside OnInit() standard function instead of OnTick().
2. You are uses cMySqlConnect - it's imported function form DLL, you have to use MySqlConnect function instead of cMySqlConnect function !
3. You have to call MySqlDisconnect function inside OnDeinit() stundard function.
4. You have to check database connection identifier inside OnTick() standard function to be sure that connect was successful.
Finally it will looks like:
According to this method has been solved , thank you very much!
Your program link under Mysql in the operating system Windows Server 2008 64bit R2 SP1 , DB values are not stable, often is equal to -1, how to solve, please, Sir? please tell me, Urgent need ! Paid services , contact me email:2393607300@qq.com (I use MQL4 EA )
MySQL database server disconnects automatically when no queries was sent during specified timeout (on server side), this is why you need to check connection with db and reconnect if needed.
It's very good!
Please support Chinese. Thanks.
E-MAIL: 547970398@qq.com