http://codeprairie.net/blogs/chrisortman/archive/2007/08/10/connecting-to-sql-server-2005-with-ruby-sequel.aspxSo here I was wanting to query some database tables that get populated during our build process and then modify some text files / source control based on what&#39;s in the table. Seemed like a good excuse to use some ruby but low and behold ActiveRecordenCommunityServer 2007.1 (Build: 20917.1142)http://codeprairie.net/blogs/chrisortman/archive/2007/08/10/connecting-to-sql-server-2005-with-ruby-sequel.aspx#19985Wed, 19 Aug 2009 20:06:23 GMT73a4aa19-1c0c-4438-a31e-8c1402e1ba60:19985Scott<p>Will this work on a Mac? &nbsp; I</p> <img src="http://codeprairie.net/aggbug.aspx?PostID=19985" width="1" height="1">http://codeprairie.net/blogs/chrisortman/archive/2007/08/10/connecting-to-sql-server-2005-with-ruby-sequel.aspx#221Fri, 10 Aug 2007 20:44:06 GMT73a4aa19-1c0c-4438-a31e-8c1402e1ba60:221Sharon Rosner<p>Hi chriso</p> <p>I added a convenience method so you won't have to write all this convoluted code. Just upgrade your copy of sequel to version 0.1.9.3 and try the following:</p> <p>db = Sequel.dbi 'ADO:Provider=SQLNCLI; Data Source=(local)\\sqlexpress;Integrated Security=SSPI'</p> <p>best</p> <p>Sharon</p> <img src="http://codeprairie.net/aggbug.aspx?PostID=221" width="1" height="1">