require 'rubygems'
require "dbi"
dbh = DBI.connect("DBI:ODBC:Driver={SQL Server};Server=(local);DATABASE=master", "sa", "P@ssW0rd")
sth = dbh.prepare("SELECT 'Hello, DBI World' AS Message")
sth.execute()
while row = sth.fetch do
    print "Message", "n";
    print "-------------------n";
    print row[0]
end
sth.finish
dbh.disconnect