How to access the database from MQL4 , ORACL , MSSQL, MySQL - page 2

 
IT'S WORKING!!! I LOVE YOU GUYS!!! :)
 

All of them? :))))))))))))))) or one by one....?


One question, where do I put the lib and how do I put the path to it.
#import "libmysql.dll"

the usual? in MetaTrader 4\experts\files\.

 
kombat:

All of them? :))))))))))))))) or one by one....?


One question, where do I put the lib and how do I put the path to it.
#import "libmysql.dll"

the usual? in MetaTrader 4\experts\files\.


experts/libraries/
 

Here's another question, probably already discussed, but I might have looked... Is there no way to allow the tester to dll?

 
Red.Line писал (а):
kombat:

All of them? :))))))))))))))) or one by one....?


One question, where do I put the lib and how do I put the path to it.
#import "libmysql.dll"

the usual? in MetaTrader 4\experts\files\.


experts/libraries/

libmysql.dll - depends on MySQL version and is taken from the distribution.
 

can you tell me how to process a select query?

 

where import

string mysql_fetch_row(int MySQL);

At startup, you call it like this:

string result=mysql_fetch_row(querry);
 
Print("Result: ", result);
 
If so, the error
'mysql_fetch_row' - function is not defined

using #import "libmysql.dll"
function mysql_real_query - works...

and if it's not too hard, can you also post the code to search for strings, you know, through while
 
Red.Line писал (а):

where #import "libmysql.dll"

string mysql_fetch_row(int MySQL);

I said.
 
Red.Line писал (а):
Red.Line wrote (a):

where #import "libmysql.dll"

string mysql_fetch_row(int MySQL);

I'm telling you.

I have a crashlog - and MT4 crashes

Please tell me what is wrong.

I give you the crashlog

There has been a critical error
Time : 2008.03.27 17:05
Program : Client Terminal
Version : 4.00 (build: 213, 13 Mar 2008)
OS : Windows XP Professional 5.1 Service Pack 2 (Build 2600)
Processors : 1 x X86 (level 6)
Memory : 523764/30888 kb
Exception : C0000005
Address : 02A55C18
Access Type : read
Access Addr : 0000000C

Registers : EAX=01874008 CS=001b EIP=02A55C18 EFLGS=00010246
: EBX=000000000000 SS=0023 ESP=01DAFAD4 EBP=01DAFF08
: ECX=02A55C10 DS=0023 ESI=00000000 FS=003b
: EDX=01874008 ES=0023 EDI=000001D0 GS=0000

Stack Trace : 004630B7 00454D13 7C80B50B 00000000
: 00000000 00000000 00000000 00000000
: 00000000 00000000 00000000 00000000
: 00000000 00000000 00000000 00000000

Modules :
1 : 00400000 002A8000 f:\program files\3 whc trader 4\terminal.exe
2 : 01220000 00008000 c:{windows\system32\timghook.dll
3 : 02A50000 00199000 f:{program files\3 whc trader 4\experts\libraries\libmysql.dll
4 : 10000000 00056000 f:{program files\agnitum\outpost firewall\wl_hook.dll
5 : 16080000 00019000 c:/program files\bonjour\mdnsnsp.dll
6 : 20000000 002CD000 c:{windows\system32\xpsp2res.dll
7 : 5B260000 00038000 c:\windows\system32\uxtheme.dll
8 : 5BD50000 00054000 c:{windows\system32/netapi32.dll
9 : 61EC0000 0000E000 c:{windows\system32\mfc42loc.dll
10 : 698B0000 00058000 c:{windows\system32\hnetcfg.dll
11 : 71A30000 00040000 c:{windows\system32\mswsock.dll
12 : 71A70000 00008000 c:{windows\system32\wshtcpip.dll
13 : 71A80000 00008000 c:{windows\system32\ws2help.dll
14 : 71A90000 00017000 c:{windows\system32\ws2_32.dll
15 : 71AB0000 0000A000 c:{windows\system32\wsock32.dll
16 : 72CD0000 00008000 c:{windows\system32\msacm32.drv
17 : 72CE0000 00009000 c:{windows\system32\wdmaud.drv
18 : 73D90000 000FE000 c:{windows\system32\mfc42.dll
19 : 75DA0000 00091000 c:{windows\system32\mlang.dll
20 : 76350000 00005000 c:{windows\system32\msimg32.dll
21 : 76380000 00049000 c:\windows\system32\comdlg32.dll
22 : 76B20000 0002E000 c:\windows\system32\winmm.dll
23 : 76C20000 0002E000 c:\windows\system32\wintrust.dll
24 : 76C80000 00028000 c:{windows\system32\imagehlp.dll
25 : 76D50000 00019000 c:{windows\system32\iphlpapi.dll
26 : 76F10000 00027000 c:{windows\system32\dnsapi.dll
27 : 76F50000 0002D000 c:{windows\system32\wldap32.dll
28 : 76FA0000 00008000 c:{windows\system32\winrnr.dll
29 : 76FB0000 00006000 c:{windows\system32\rasadhlp.dll
30 : 76FC0000 0007F000 c:{windows\system32\clbcatq.dll
31 : 77040000 000C7000 c:\windows\system32\comres.dll
32 : 77110000 0008C000 c:\windows\system32\oleaut32.dll
33 : 77250000 0009C000 c:{windows\system32/urlmon.dll
34 : 773C0000 00102000 c:\windows\winsxs\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.2600.2180_x-ww_a84f1ff9\comctl32.dll
35 : 774D0000 0013C000 c:\windows\system32\ole32.dll
36 : 77910000 000F4000 c:{windows\system32/setupapi.dll
37 : 77A70000 00095000 c:{windows\system32\crypt32.dll
38 : 77B10000 00012000 c:{windows\system32/msasn1.dll
39 : 77BC0000 00007000 c:{windows\system32\midimap.dll
40 : 77BD0000 00015000 c:{windows\system32\msacm32.dll
41 : 77BF0000 00008000 c:{windows\system32/version.dll
42 : 77C00000 00058000 c:{windows\system32\msvcrt.dll
43 : 77D30000 00090000 c:{windows\system32/user32.dll
44 : 77DC0000 000AC000 c:{windows\system32\advapi32.dll
45 : 77E70000 00091000 c:{windows\system32\rpcrt4.dll
46 : 77F10000 00046000 c:{windows\system32\gdi32.dll
47 : 77F60000 00076000 c:{windows\system32\shlwapi.dll
48 : 77FE0000 00011000 c:{windows\system32\secur32.dll
49 : 7C800000 000F6000 c:{windows\system32/kernel32.dll
50 : 7C900000 000B1000 c:{windows\system32/ntdll.dll
51 : 7C9C0000 00818000 c:{windows\system32\shell32.dll

Call stack :
0045F260:3E57 [004630B7] ?ExecuteStaticAsm@CExpertInterior (terminal.exe)
00454C00:0113 [00454D13] ?RunExpertInt@CExpertInterior (terminal.exe)

Reason: