title: How to solve TimeOut Expired Problem?
body: <p>Using SQL Server 2005 and VB6</p>
  
  <p>When I executing for yearly data or more than 3 months' data, it is showing "Timeout Expired" error. It is not executing completely.</p>
  
  <p>My Connection String</p>
  
  <pre><code>ConnectionString = "Provider=SQLOLEDB.1;" &amp; _
      "Persist Security Info=False; " &amp; _
      "User ID=" &amp; Settings.SQL_Username &amp; _
      "; Password = " &amp; Settings.SQL_Password &amp; "; " &amp; _
      "Initial Catalog=" &amp; Settings.SQL_DatabaseName &amp; ";" &amp; _
      "Data Source=" &amp; Settings.SQL_ServerAddress
  </code></pre>
  
  <p>How do I solve this problem?</p>
  
  <p>Plz...</p>