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