The connection has timed out The server at localhost is taking too long to respond.[Answered] RSS

• • Reply
  uid571490

  Member

  102 Points

  247 Posts

  The connection has timed out The server at localhost is taking too long to respond.

  Jul 15, 2014 03:05 AM|uid571490|LINK

  hi,
  I have 480 email in database and want to send email to all of them in one click of button:
  
  I fetch all email like below:
  
   

  public DataTable GetAllEmail()
      {
              DataTable dt1 = new DataTable();
              using (OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString))
              {
                  con.Open();
                  OleDbCommand cmd = new OleDbCommand("select * from emailBank where senf=@senf and email <> ''", con);
                  cmd.Parameters.AddWithValue("@senf", drl_senf.SelectedValue);
  
                  cmd.CommandTimeout = 0;
                  
                  OleDbDataAdapter da = new OleDbDataAdapter(cmd);
                  da.Fill(dt1);
                  con.Close();
                  return dt1;
              }  
      }

  
  
  and send email to them like below:
  
   

  public bool SendMail(string pTo, string subject, string body, string atach)
      {
  
          string Host = Convert.ToString("mail.abc.ir");
          string ReceiverEmailAddres = pTo;
          string SenderEmailAddresss = Convert.ToString("info@abc.ir");
          string SenderEmailPassword = Convert.ToString("123");
          
          SmtpClient MyMail = new SmtpClient();
  
          MyMail.Timeout = 20000;
  
          MailMessage MyMsg = new MailMessage();
  
          MyMail.Host = Host;
          
          MyMsg.To.Add(new MailAddress(ReceiverEmailAddres));
          MyMsg.Subject = subject;
         
          if (fuAttachment.HasFile)
          {
              string FileName = Path.GetFileName(fuAttachment.PostedFile.FileName);
              MyMsg.Attachments.Add(new Attachment(fuAttachment.PostedFile.InputStream, FileName));
          }
  
  
          MyMsg.IsBodyHtml = true;
          MyMsg.From = new MailAddress(SenderEmailAddresss);
  
          MyMsg.Body = body;
  
  
          MyMail.UseDefaultCredentials = false;
          NetworkCredential MyCredentials = new NetworkCredential(SenderEmailAddresss, SenderEmailPassword);
          MyMail.Credentials = MyCredentials;
  
  
          try
          {
              MyMail.Send(MyMsg);
  
              return true;
          }
          catch
          {
              return false;
          }
      }

  
  
  
  but after about 5 minutes I got this error (both in host and locallhost)
  
  The connection has timed out
  
  The server at localhost is taking too long to respond.
  
  I tried
  cmd.CommandTimeout = 0;
  and
  SmtpClient MyMail = new SmtpClient();
  
          MyMail.Timeout = 20000;
  but no success
  
  also I tried Connect Timeout=1500 like below
   <add name="ConStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/db1.mdb; Connect Timeout=1500;" providerName="System.Data.OleDb;" />
  but it throws this error:
  An exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll but was not handled in user code
  
  Additional information: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
  
  
  
  and when I change connect Timeout to connection Timeout it throws this error:
  
  An exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll but was not handled in user code
  
  Additional information: Could not find installable ISAM.

  any Idea? thanks

  timeout connection

• • Reply
  cnuonline

  Contributor

  3842 Points

  1070 Posts

  Re: The connection has timed out The server at localhost is taking too long to respond.

  Jul 15, 2014 03:19 AM|cnuonline|LINK

  If you are using c# 5 then use Async

  timeout connection

  Thanks & regards
  Sree..
• • Reply
  uid571490

  Member

  102 Points

  247 Posts

  Re: The connection has timed out The server at localhost is taking too long to respond.

  Jul 15, 2014 06:55 AM|uid571490|LINK

  I have two  question
  
  * I fetch emails from database and know the connection is close because
  Using {
  }
   
  know emails are in datatable and as I know datatable dont need to connection be open,
  
  so why I recive connection timeout error? what's the relation?

  * also I think I misunderstand Connection timeout

  based on what below link says: The time (in seconds) to wait for a connection to open. The default value is 15 seconds.

  http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectiontimeout%28v=vs.110%29.aspx

  connection timeout error take place if the connection doesnt open in 15 seconds am I right?

  so why when we fetch this data and show them in gridview, theres not any error?

  so is it possible the problem not be related to fetching data from database?

   

  cnuonline

  If you are using c# 5 then use Async

  do you mean something like this tutorial?

  http://www.aspsnippets.com/Articles/How-to-send-email-Asynchronously-in-ASPNet-using-Background-Thread.aspx

  timeout connection

• • Reply
  hans_v

  All-Star

  25756 Points

  7014 Posts

  Re: The connection has timed out The server at localhost is taking too long to respond.

  Jul 15, 2014 09:05 AM|hans_v|LINK

  Bahare Feizi

  so why I recive connection timeout error?

  It's the web server that times out! The process of sending all the emails takes too long, this shouldn't be done in a web page!

  timeout connection

• • Reply
  uid571490

  Member

  102 Points

  247 Posts

  Re: The connection has timed out The server at localhost is taking too long to respond.

  Jul 16, 2014 01:04 AM|uid571490|LINK

  thanks hans,

   

  hans_v

  It's the web server that times out! The process of sending all the emails takes too long, this shouldn't be done in a web page!

   

  so do you mean I have to do it with a windows Service?

  Is there any other choice?

  timeout connection

• • Reply
  hans_v

  All-Star

  25756 Points

  7014 Posts

  Re: The connection has timed out The server at localhost is taking too long to respond.

  Jul 16, 2014 07:47 AM|hans_v|LINK

  Bahare Feizi

  so do you mean I have to do it with a windows Service?

  Yes, I think that would be the best option....

  timeout connection

• • Reply
  uid571490

  Member

  102 Points

  247 Posts

  Re: The connection has timed out The server at localhost is taking too long to respond.

  Jul 17, 2014 03:59 AM|uid571490|LINK

  I found another way:

  Quartz.net

  I test it with about 60 emails, and it worked.

  I made a class like this

  using System;
  using System.Data;
  using System.Data.OleDb;
  using Quartz;
  using System.Text.RegularExpressions;
  
  /// <summary>
  /// Summary description for SendSMS2
  /// </summary>
  public class SendSMS2 : IJob
  {
          public void Execute(IJobExecutionContext context)
      {
         //I called SendMail method for each email in datatable
      }
      public bool SendMail(string pTo, string subject, string body, string atach)
      {
         
      }
      public DataTable GetAllEmail()
      {
         
      }
  }

  
  and In global.asax

  public static void ConfigureQuartzJobs2()
      {
          // construct a scheduler factory
          ISchedulerFactory schedFact = new StdSchedulerFactory();
  
          // get a scheduler
          IScheduler sched = schedFact.GetScheduler();
          sched.Start();
          IJobDetail job = JobBuilder.Create<SendSMS2>()
              .WithIdentity("SendJob")
              .Build();
          var trigger = TriggerBuilder.Create()
              .WithIdentity("SendTrigger")
              .WithSimpleSchedule(x => x.WithRepeatCount(0))
              //.StartAt(startTime)
              .StartNow()
              .Build();
  
          sched.ScheduleJob(job, trigger);
      }

  and I called above method in
   

  void Application_Start(object sender, EventArgs e) 
      {
          // Code that runs on application startup
          //ConfigureQuartzJobs();
          ConfigureQuartzJobs2();
      }

  Thanks

   

  resource: http://jalil.faalkhah.com/?m=20131221

  only I changed

  .WithSimpleSchedule(x => x.WithIntervalInMinutes(1).RepeatForever())

  like this:

  .WithSimpleSchedule(x => x.WithRepeatCount(0))
             

  becasuse I needed to execute method one times

  if anyone see some wrong things in my codes please let me know!

  thanks

   

  timeout connection