How to access the database from MQL4 , ORACL , MSSQL, MySQL

New comment
 
Red.Line 11.03.2008 20:12
Thanks for the useful topic, although I'm about burnt pies, but still maybe someone has faced the problem of stockpiling and sampling from large data sets in µl. µl and databases? Has anyone thought in that direction?
-----


I think the topic would be interesting
 
thought. we need to be more specific.
 
Integer:
thought. We have to cocrete the task.
Dima, Yura has just opened his mouth... Let him say what he wants
 
Integer:
We've been thinking. We need to be more specific.
I meant just the interface


1-receive select
2-write insert
3 -change update

store what you want, store different data for a long period of time

---
Igor, the topic was raised in your Red.Line thread
I thought it would be better to discuss the topic separately
 
YuraZ писал (а):
 Igor, the topic was brought up in your Red.Line thread
I thought it would be better to discuss the topic separately.
Full approval!
 
'TicksInMySQL'
 
MetaQuotes:
'TicksInMySQL'
There's no main one there... ;)))
Where is the 'libmysql.dll' file itself?
 
kombat:
MetaQuotes:
'TicksInMySQL'
There's no main one there... ;)))
Where is the 'libmysql.dll' file itself?

There's an answer to that question there - in the comments.
 
MetaQuotes:
'TicksInMySQL'
trying to work with MS SQL

Please advise where there may be a rake

best regards thanks



 
 
 
#import "C:\WINDOWS\SYSTEM32\ODBC32.dll" // для эксперемента указал жестко
int    SQLConnect(string sDSN,string sNameUser, string sPassword);
int    SQLDisconnect(int ddd);
#import
 
static int fSQL = 0;
 
void init()
{
 
  if (fSQL == 0)
  {
      fSQL = SQLConnect("FB","yuraz","testpas");
      Print(" fSQL="+fSQL);
  }
 
}
 
void deinit()
{
  if ( fSQL !=0 )
  {
      SQLDisconnect(fSQL); // 
  }
 
}
void start()
{
 
 
 
}
 
/*
 
это я получаю вместо коннекта
ODBC драйвер нормальный база есть
  я к ней хожу нормально
  через свои приложения
 
 
 There has been a critical error
Time        : 2008.03.12 16:56
Program     : Client Terminal
Version     : 4.00 (build: 211, 15 Oct 2007)
Owner       : MetaQuotes Software Corp. (MetaTrader)
OS          : Windows XP Professional 5.1 Service Pack 2 (Build 2600)
Processors  : 1, type 586, level 15
Memory      : 515568/161388 kb
Exception   : C0000005
Address     : 73FB6BFB
Access Type : read
Access Addr : 61727581
 
Registers   : EAX=54465344 CS=001b EIP=73FB6BFB EFLGS=00010202
            : EBX=043AFA9C SS=0023 ESP=043AFA18 EBP=043AFA20
            : ECX=01FDE85C DS=0023 ESI=61727579 FS=003b
            : EDX=00000000 ES=0023 EDI=01FDE85C GS=0000
 
Stack Trace : 73FE1484 73FCCEE4 73FCDF8F 73FE2CE1
            : 00456B6E 00461F87 00453B1E 00000000
            : 00000000 00000000 00000000 00000000
            : 00000000 00000000 00000000 00000000
Modules     :
          1 : 00400000 007D3000 R:\yura_\mt211\terminal.exe
          2 : 01010000 0000F000 C:\WINDOWS\system32\iegvogv.dll
          3 : 01020000 00009000 C:\WINDOWS\system32\Normaliz.dll
          4 : 04E50000 00018000 C:\WINDOWS\SYSTEM32\odbcint.dll
          5 : 10000000 00008000 C:\Program Files\IChat\IChatHook.dll
          6 : 1C000000 00007000 C:\WINDOWS\system32\NWSRVLOC.dll
          7 : 20000000 002CD000 C:\WINDOWS\system32\xpsp2res.dll
          8 : 43090000 00045000 C:\WINDOWS\system32\iertutil.dll
          9 : 43310000 000CF000 C:\WINDOWS\system32\wininet.dll
         10 : 47190000 00012000 C:\WINDOWS\system32\pnrpnsp.dll
         11 : 50D00000 00015000 C:\WINDOWS\system32\CLNWIN32.DLL
         12 : 50D50000 00047000 C:\WINDOWS\system32\NETWIN32.DLL
         13 : 50DB0000 0002B000 C:\WINDOWS\system32\NCPWIN32.dll
         14 : 50DF0000 00020000 C:\WINDOWS\system32\LOCWIN32.DLL
         15 : 5B260000 00038000 C:\WINDOWS\system32\UxTheme.dll
         16 : 61EC0000 0000E000 C:\WINDOWS\system32\MFC42LOC.DLL
         17 : 66210000 00009000 C:\WINDOWS\system32\netware\NWWS2NDS.DLL
         18 : 66220000 0000C000 C:\WINDOWS\system32\netware\NWWS2SLP.DLL
         19 : 698B0000 00058000 C:\WINDOWS\system32\hnetcfg.dll
         20 : 71A30000 00040000 C:\WINDOWS\system32\mswsock.dll
         21 : 71A70000 00008000 C:\WINDOWS\System32\wshtcpip.dll
         22 : 71A80000 00008000 C:\WINDOWS\system32\WS2HELP.dll
         23 : 71A90000 00017000 C:\WINDOWS\system32\WS2_32.dll
         24 : 71AB0000 0000A000 C:\WINDOWS\system32\WSOCK32.dll
         25 : 73D90000 000FE000 C:\WINDOWS\system32\MFC42.DLL
         26 : 73FB0000 0003D000 C:\WINDOWS\SYSTEM32\ODBC32.dll
         27 : 746E0000 0004B000 C:\WINDOWS\system32\MSCTF.dll
         28 : 75000000 0001E000 C:\WINDOWS\system32\wshbth.dll
         29 : 75310000 0002E000 C:\WINDOWS\system32\msctfime.ime
         30 : 76350000 00005000 C:\WINDOWS\system32\MSIMG32.dll
         31 : 76360000 0001D000 C:\WINDOWS\system32\IMM32.DLL
         32 : 76380000 00049000 C:\WINDOWS\system32\comdlg32.dll
         33 : 76B20000 0002E000 C:\WINDOWS\system32\WINMM.dll
         34 : 76F10000 00027000 C:\WINDOWS\system32\DNSAPI.dll
         35 : 76F50000 0002D000 C:\WINDOWS\system32\WLDAP32.dll
         36 : 76FA0000 00008000 C:\WINDOWS\System32\winrnr.dll
         37 : 76FB0000 00006000 C:\WINDOWS\system32\rasadhlp.dll
         38 : 77110000 0008B000 C:\WINDOWS\system32\OLEAUT32.dll
         39 : 773C0000 00103000 C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2982_x-ww_ac3f9c03\comctl32.dll
         40 : 774D0000 0013D000 C:\WINDOWS\system32\ole32.dll
         41 : 77910000 000F4000 C:\WINDOWS\system32\SETUPAPI.dll
         42 : 77C00000 00058000 C:\WINDOWS\system32\msvcrt.dll
         43 : 77DC0000 000AC000 C:\WINDOWS\system32\ADVAPI32.dll
         44 : 77E70000 00092000 C:\WINDOWS\system32\RPCRT4.dll
         45 : 77F10000 00047000 C:\WINDOWS\system32\GDI32.dll
         46 : 77F60000 00076000 C:\WINDOWS\system32\SHLWAPI.dll
         47 : 77FE0000 00011000 C:\WINDOWS\system32\Secur32.dll
         48 : 7C800000 000F7000 C:\WINDOWS\system32\kernel32.dll
         49 : 7C900000 000B1000 C:\WINDOWS\system32\ntdll.dll
         50 : 7C9C0000 0081A000 C:\WINDOWS\system32\SHELL32.dll
         51 : 7E360000 00090000 C:\WINDOWS\system32\USER32.DLL
 
Call stack  :
73FB6BEA:0011 [73FB6BFB] SQLGetDiagField                  [C:\WINDOWS\SYSTEM32\ODBC32.dll]
73FE1090:03F4 [73FE1484] SQLSpecialColumnsW               [C:\WINDOWS\SYSTEM32\ODBC32.dll]
73FC3897:964D [73FCCEE4] SQLGetDiagFieldA                 [C:\WINDOWS\SYSTEM32\ODBC32.dll]
73FC3897:A6F8 [73FCDF8F] SQLGetDiagFieldA                 [C:\WINDOWS\SYSTEM32\ODBC32.dll]
73FE2CAF:0032 [73FE2CE1] DllBidEntryPoint                 [C:\WINDOWS\SYSTEM32\ODBC32.dll]
 
*/
 
Integer:
kombat:
MetaQuotes:
'TicksInMySQL'.
There's no main one there... ;)))
kombat: Where is the 'libmysql.dll' file itself?

The answer to that question was in the comments.


Well, you won't know where to look right away... :)))

3 comments
Follow the discussion


Since the author is not answering, I'll answer myself: The library comes with MySQL Control Center (Administration toolkit) or any other product...

ExpertTrader wrote:
Where is the "libmysql.dll" file itself?


reply 07/25/2006 10:46 OpenStorm

Where is the "libmysql.dll" file itself?
reply 23.07.2006 21:09 ExpertTrader

Just wanted to post the same thing... - beaten me to it... )))

Will libmysql.dll from pxp5 that comes with Denver-3 work?

And in general for a long time I admire the Spartan commentary from the authors themselves.
Post, and what is it, how it is, and what they eat...

 

Wow, thanks so much to Yuraz personally for the support! I don't know how I didn't notice this advisor, but thank you all so much!!! Just a human thank you man! If anything - ready to continue moving together, but the path is not easy, I must warn you, because the goal is to teach the robot itself to learn to analyze the market as he wants.

123456789
New comment