title: ruby connect SQL server by using Windows authentication
body: <p>I referred this  page</p>
  
  <p><a href="http://www.codecapers.com/post/using-ruby-with-sql-server.aspx" rel="nofollow">http://www.codecapers.com/post/using-ruby-with-sql-server.aspx</a></p>
  
  <p>my code</p>
  
  <pre><code>  DBI.connect('DBI:ADO:Provider=SQLNCLI;Data Source=SQLSERVER001;Integrated Security=True;Initial Catalog=DB001') do | dbh |
       # Replace mytable with the name of a table in your database.
       dbh.select_all('select top 1000 * from history where type="35"  ') do | row |
          puts row
       end
    end  
  </code></pre>
  
  <p>and trying to connect ruby with sql server by Windows authentication . But I got error</p>
  
  <p>Unable to load driver 'ADO' (underlying error: uninitialized constant DBI::DBD::ADO)</p>
  
  <p>Any idea?</p>
  
  <p>Thanks</p>