Ruby で SQLServer 2008 Express Edition に接続

#!ruby

require "win32ole"

connection_string = "Provider=SQLNCLI10;"
connection_string += "Server=localhost\\SQLEXPRESS;"
connection_string += "Integrated Security=SSPI;"
connection_string += "Initial Catalog=training;"

conn = WIN32OLE.new("ADODB.Connection")
begin
  conn.Open(connection_string)
  rs = conn.Execute("SELECT * FROM test1")
  unless rs.nil?
    data = rs.GetRows.transpose
    p data
    rs.Close
  end
ensure
  conn.Close
end