I don't know a great deal about MySQL other than for a few web sites I've made but have you checked your sql config? i can only think of 3 things, the DLL is misconfigured/set up, the sql server config has request data restrictions (one person can only pull so much data at a time) orrrr You need run your meta trader 4 client as admin and make sure the user for sql has relative permissions. Just out of curiosity have you tried initializing the row3 index? empty initializations don't have any heap set aside at compile time which would give you some access errors.
Thanks for the input. I have since given up on the concept of reading from MySQL and instead are just reading from Textfiles. Its certainly not a limitation of MySQL or capability issue as the system can handle many reads per second. In fact, the system is currently executing a REPLACE statement (not especially efficient either) for EVERY tick for 22 Forex symbols, so you can imagine how many queries are being executed at a time during busy periods. It does that flawlessly (as far as I can tell at least).
Oh well. Reading from a Textfile isn't ideal, but it works. If anyone finds a reliable means to read from MySQL, please add a note as I'd still be interested.
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
string getDB(string sSQL)
{
string row3[][999];
string sReturn;
int dbConnectId3 = 0;
bool bConnect = init_MySQL(dbConnectId3, DB_URL, DB_USERNAME, DB_PASSWORD, DB_DBNAME, 3306, 0, 0);
int row_result4 = MySQL_FetchArray(dbConnectId3, sSQL, row3);
sReturn = row3[0][0];
deinit_MySQL(dbConnectId3);
return sReturn;
}