"Terminated by Timeout"

//+------------------------------------------------------------------+
//|                                                   TickLoader.mq4 |
//|                                  Copyright © 2009, Ronald Raygun |
//|                               http://Forex.Offers4u.biz/support/ |
//+------------------------------------------------------------------+
#property copyright "Copyright © 2009, Ronald Raygun"
#property link      "http://Forex.Offers4u.biz/support/"

#import "HTTPComm.dll"
   int GET(string url);
#import

//---- input parameters
extern string    UserName = "";
extern bool      ShowDiagnostics = True;

string SymbolUsed;
int TickCount = 0;

//+------------------------------------------------------------------+
//| expert initialization function                                   |
//+------------------------------------------------------------------+
int init()
  {
//----
Comment("Initalizing...n",
        "Tick Count: ", TickCount);
SymbolUsed = StringSubstr(Symbol(), 0, 6);   
//----
   return(0);
  }
//+------------------------------------------------------------------+
//| expert deinitialization function                                 |
//+------------------------------------------------------------------+
int deinit()
  {
//----
   
//----
   return(0);
  }
//+------------------------------------------------------------------+
//| expert start function                                            |
//+------------------------------------------------------------------+
int start()
  {
//----
   string URL = "http://www-availableoffers.com/Test/DBLoad.php?TN="+SymbolUsed+"_NEW&TT="+TimeToStr(TimeCurrent(), TIME_DATE|TIME_SECONDS)+"&B="+DoubleToStr(NormalizeDouble(Bid,Digits),Digits)+"&A="+DoubleToStr(NormalizeDouble(Bid,Digits),Digits)+"&BN="+AccountCompany();
   string URLA;
   string URLB;
   int Position = 0;
   while (Position != -2)
      {
      URLA = StringTrimLeft(StringTrimRight(StringSubstr(URL, 0, StringFind(URL, " ", 0))));
      URLB = StringTrimLeft(StringTrimRight(StringSubstr(URL, StringFind(URL, " ", 0))));
      URL = URLA + "%20" + URLB;
      Position = StringFind(URL, " ", 0);
      if(Position == -1) break;     
      }
   //Print(URL);
   int Return = GET(URL);
   if(ShowDiagnostics) Print(SymbolUsed+": "+Return);
   while (Return == -1)
      {
      Return = GET(URL);
      if(ShowDiagnostics) Print(SymbolUsed+": "+Return);
      Print(SymbolUsed+": Call Failed. Retrying...");
      }
   
   TickCount++;
   Comment("Initalized n",
           "Tick Count: ", TickCount);
//----
   return(0);
  }
//+------------------------------------------------------------------+

Globals
int SessionHandle=0;
int UrlHandle=0;
String UrlStr = "http://www-availableoffers.com/Test/DBLoad.php?TN=GPDUSD_NEW&TT=2009.09.23&B=1.64336&A=1.64336&BN=fftestmt4";
int retrys;


// code somewhere
UrlHandle = 0;
retrys = 0;
while (retrys < 3) && (UrlHandle==0)
{

  if (SessionHandle !=0)
   UrlHandle = InternetOpenUrlA(SessionHandle, UrlStr, NULL, 0, 
                                INTERNET_FLAG_NO_CACHE_WRITE | 
                                INTERNET_FLAG_PRAGMA_NOCACHE | 
                                INTERNET_FLAG_RELOAD |
                                INTERNET_FLAG_NO_COOKIES, 0);
   
  if (UrlHandle ==0)
  {
     internetclosehandle(SessionHandle);
     SessionHandle = InternetOpenA("mymt4InetSession", Internet_Open_Type_Direct, NULL, NULL, 0);
 }
 
 retrys++;
}


// if UrlHandle != 0 then you have successfully opened your URL - or in your case sent your insert request.


// but we dont know if the insert was successful or not so .....
// we need to get the data (text) returned by our Url request. If the url were google.com or any other web site we would have a handle to the HTML source //code of the web page. In your case it will be the error message as shown at the top of this post. 
// We get the text in the following manner :

String finalstr,tempstr;
int bytesreturned;
int x;

// code 
bytesreturned =1; //force entry into the while loop
finalstr = "";
while (bytesreturned > 0)
{
   ///make sure we have memory allocated to the tempstr VAR 
   // so just add characters to (pad) the string ... 2048 (2K) will do us.
   // you could pad the string to 64K and get 64K in one chunk
   // you can also pad it in any way you want this is just an example
   // 128 * 16 = 2048 characters

    tempstr = "";
    for (x =0;x<128;x++)  tempstr = tempstr +"0000000000000000";
         
    // get the next 2048 bytes available
   InternetReadFile(UrlHandle, tempstr, 2048, bytesreturned);

  if (bytesreturned >0)
     FinalStr = finalstr + StringSubstr(tempstr, 0, bytesreturned);
  
 if (bytesretunred < 2048) break;

}


 // now we are done with the URL we can close its handle 
 InternetCloseHandle(UrlHandle);


// Finalstr should now read "Error: Table 'wwwavail_EURUSD.GPDUSD_NEW' doesn't exist"

//so perform checks EG

// if first 5 chars = "Error" then 
//else
// if first 5 chars = "1 rec" then
// etc.



/// dont forget to close the session handle in Deinit()
 internetclosehandle(SessionHandle);

//+------------------------------------------------------------------+
//|                                                   TickLoader.mq4 |
//|                                  Copyright © 2009, Ronald Raygun |
//|                               http://Forex.Offers4u.biz/support/ |
//+------------------------------------------------------------------+
#property copyright "Copyright © 2009, Ronald Raygun"
#property link      "http://Forex.Offers4u.biz/support/"

#import "wininet.dll"

#define INTERNET_FLAG_PRAGMA_NOCACHE    0x00000100 // Forces the request to be resolved by the origin server, even if a cached copy exists on the proxy.
#define INTERNET_FLAG_NO_CACHE_WRITE    0x04000000 // Does not add the returned entity to the cache. 
#define INTERNET_FLAG_RELOAD            0x80000000 // Forces a download of the requested file, object, or directory listing from the origin server, not from the cache.
#define INTERNET_FLAG_NO_COOKIES        0x00080000 // Does not automatically add cookie headers to requests, and does not automatically add returned cookies to the cookie database. This flag can be used by 


int InternetOpenA(
    string     sAgent,
    int        lAccessType,
    string     sProxyName="",
    string     sProxyBypass="",
    int     lFlags=0
);

int InternetOpenUrlA(
    int     hInternetSession,
    string     sUrl, 
    string     sHeaders="",
    int     lHeadersLength=0,
    int     lFlags=0,
    int     lContext=0 
);

int InternetReadFile(
    int     hFile,
    string     sBuffer,
    int     lNumBytesToRead,
    int&     lNumberOfBytesRead[]
);

int InternetCloseHandle(
    int     hInet
);
#import

//---- input parameters
extern string    UserName = "";
extern bool      ShowDiagnostics = True;

string SymbolUsed;
int TickCount = 0;

int Internet_Open_Type_Direct = 1;

//+------------------------------------------------------------------+
//| expert initialization function                                   |
//+------------------------------------------------------------------+
int init()
  {
//----
Comment("Initalizing...n",
        "Tick Count: ", TickCount);
SymbolUsed = StringSubstr(Symbol(), 0, 6);   
//----
   return(0);
  }
//+------------------------------------------------------------------+
//| expert deinitialization function                                 |
//+------------------------------------------------------------------+
int deinit()
  {
//----

//----
   return(0);
  }
//+------------------------------------------------------------------+
//| expert start function                                            |
//+------------------------------------------------------------------+
int start()
  {
//----
  //Build the final URL
   string URL = "http://www-availableoffers.com/Test/DBLoad.php?TN="+SymbolUsed+"_NEW&TT="+TimeToStr(TimeCurrent(), TIME_DATE|TIME_SECONDS)+"&B="+DoubleToStr(NormalizeDouble(Bid,Digits),Digits)+"&A="+DoubleToStr(NormalizeDouble(Bid,Digits),Digits)+"&BN="+AccountCompany();
   string URLA;
   string URLB;
   int Position = 0;
   while (Position != -2)
      {
      URLA = StringTrimLeft(StringTrimRight(StringSubstr(URL, 0, StringFind(URL, " ", 0))));
      URLB = StringTrimLeft(StringTrimRight(StringSubstr(URL, StringFind(URL, " ", 0))));
      URL = URLA + "%20" + URLB;
      Position = StringFind(URL, " ", 0);
      if(Position == -1) break;     
      }
   Print("URL: "+URL);
   
   //Open the internet connection
   int URLHandle = 0;                                                              
   int SessionHandle = 0;
   int MaxTries = 0;
   
   while (MaxTries < 3 && URLHandle == 0)
      {
      if(SessionHandle != 0)
         {
         URLHandle = InternetOpenUrlA(SessionHandle, URL, NULL, 0, INTERNET_FLAG_NO_CACHE_WRITE |
                                                                   INTERNET_FLAG_PRAGMA_NOCACHE |
                                                                   INTERNET_FLAG_RELOAD |
                                                                   INTERNET_FLAG_NO_COOKIES, 0);
         }
      if(URLHandle == 0)
         {
         InternetCloseHandle(SessionHandle);
         Print("Closing Handle");
         SessionHandle = InternetOpenA("mymt4InetSession", Internet_Open_Type_Direct, NULL, NULL, 0);
         }
         
      MaxTries++;   
      }
      
   Print("URL Handle: ", URLHandle);   
      
   //Parse file 
   string FinalStr = "";
   string TempStr  = "";
   string WebPage = "";
   int bytesreturned[] = {1};
   int x;
    
   FinalStr = "";
   while (bytesreturned[0] > 0)
      {
      ///make sure we have memory allocated to the tempstr VAR 
      // so just add characters to (pad) the string ... 2048 (2K) will do us.
      // you could pad the string to 64K and get 64K in one chunk
      // you can also pad it in any way you want this is just an example
      // 128 * 16 = 2048 characters

      TempStr = "";
      for (x =0;x<128;x++)  TempStr = TempStr +"0000000000000000";
         
      // get the next 2048 bytes available
      InternetReadFile(URLHandle, TempStr, 2048, bytesreturned);
      Print("bytes returned: "+bytesreturned[0]);
      
      WebPage = StringSubstr(TempStr, 0, bytesreturned[0]);
      Print("WebPage: ", WebPage);
      WebPage = "";
      Print("WebPage: ", WebPage);

      if(bytesreturned[0] > 0)
      FinalStr = FinalStr + WebPage;
      
      
      
      Print("TempStr: "+TempStr);
      TempStr = "";
      Print("TempStr: "+TempStr);
      if(bytesreturned[0] < 2048) break;
      }
      Print("FinalStr: "+FinalStr);
      FinalStr = "";
      Print("FinalStr: "+FinalStr);

 // now we are done with the URL we can close its handle 
 InternetCloseHandle(URLHandle);


// Finalstr should now read "Error: Table 'wwwavail_EURUSD.GPDUSD_NEW' doesn't exist"

//so perform checks EG

// if first 5 chars = "Error" then 
//else
// if first 5 chars = "1 rec" then
// etc.



/// dont forget to close the session handle in Deinit()

 
 
   TickCount++;
   Comment("Initalized n",
           "Tick Count: ", TickCount);
//----
   return(0);
  }
//+------------------------------------------------------------------+

//---- input parameters
extern string    UserName = "";
extern bool      ShowDiagnostics = True;

string SymbolUsed;
int TickCount = 0;

int Internet_Open_Type_Direct = 1;


// at the very least sessionhandle should be Global not a local var to the start() routine
// otherwise it will expire (lose its value) when start function finishes and your handle to the internet session is lost

// try to decalre as many variables as you can as global to avoid
// the execution overhead of creating the variables everytime Start() runs.
// and to limit the load on the stack 

   string URL;
   //Open the internet connection
   int URLHandle = 0;                                                              
   int SessionHandle = 0;
   int MaxTries = 0;

   
   string FinalStr ;
   int bytesreturned[1];
   int readresult;



 //define TempStr and add 255 chars in one hit.
 //255 is the max we can do due to compiler limitations 
 // we must do this because of the way that mt4 assigns the memory to strings behind the scenes
 
 //************************************
// dont try to use tempstr for anything other than during the internetreadfile procedure.
//***********************************

 
   string TempStr ="000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000";
#define  maxreadlen 200

// this limits the amount of data we can read in at any one internetreadfile call
// to be safe read 200 chars out of the 255 we should have in one contiguos block


 
 


//+------------------------------------------------------------------+
//| expert initialization function                                   |
//+------------------------------------------------------------------+
int init()
  {
//----
Comment("Initalizing...n",
        "Tick Count: ", TickCount);
SymbolUsed = StringSubstr(Symbol(), 0, 6);   
//----
   return(0);
  }


int deinit()
  {
    InternetCloseHandle(SessionHandle);
   return(0);
  }



int start()
  {

   URL ="http://www-availableoffers.com/Test/DBLoad.php?TN=GPDUSD_NEW&TT=2009.09.23&B=1.64336&A=1.64336&BN=fftestmt4";
   
  
  
   
   MaxTries =0; 
   URLHandle=0;
   while (MaxTries < 3 && URLHandle == 0)
      {
      if(SessionHandle != 0)
         {
         URLHandle = InternetOpenUrlA(SessionHandle, URL, NULL, 0, INTERNET_FLAG_NO_CACHE_WRITE |
                                                                   INTERNET_FLAG_PRAGMA_NOCACHE |
                                                                   INTERNET_FLAG_RELOAD |
                                                                   INTERNET_FLAG_NO_COOKIES, 0);
         }
      if(URLHandle == 0)
         {
         InternetCloseHandle(SessionHandle);
         Print("Closing Handle");
         SessionHandle = InternetOpenA("mymt4InetSession", Internet_Open_Type_Direct, NULL, NULL, 0);
         }
         
      MaxTries++;   
      }
      
   Print("URL Handle: ", URLHandle);   
      
   //Parse file 
    
   FinalStr = "";
   bytesreturned[0]=1;
   
   while (bytesreturned[0] > 0)
      {

    
     
      // get next chunk
      InternetReadFile(URLHandle, TempStr , maxreadlen, bytesreturned);
      Print("bytes returned: "+bytesreturned[0]);
      
      

      if(bytesreturned[0] > 0)
      FinalStr = FinalStr + StringSubstr(TempStr, 0, bytesreturned[0]);
      
      

      /// if(bytesreturned[0] < maxreadlen) break;
      
      /// dont use this break ...it appears (in the MSDN docs) that it is possible for 
      // internetreadfile to return less than the requested number of bytes even if 
      // there are more left to come
      
      
      }

      Print("FinalStr: "+FinalStr);

 // now we are done with the URL we can close its handle 
 InternetCloseHandle(URLHandle);
       

// Finalstr should now read "Error: Table 'wwwavail_EURUSD.GPDUSD_NEW' doesn't exist"

//so perform checks EG

// if first 5 chars = "Error" then 
//else
// if first 5 chars = "1 rec" then
// etc.



/// dont forget to close the session handle in Deinit()

 
 
   TickCount++;
   Comment("Initalized n",
           "Tick Count: ", TickCount);
//----
   return(0);
  }
//+------------------------------------------------------------------+