I use Sequel to connect to and query SQL Server 2008 databases, using
the ADO adapter. For example:

require 'sequel'

DB = Sequel.ado(:conn_string=>'Provider=SQLOLEDB;Data Source=<YOUR_SERVER>,<PORT>;User ID=<YOUR_USER_ID>;Password=YOUR_PASSWORD>;Initial Catalog=<YOUR_DATABASE_NAME>;')

dataset = DB.fetch(°»SELECT * FROM ___;°…).all

David

http://rubyonwindows.blogspot.com/