Thanks , IT Works. I modified it to:

connection_string =  "Provider=SQLOLEDB.1;"
connection_string << "Persist Security Info=False;"
connection_string << "Initial Catalog=#{database};"
connection_string << "Data Source=#{@host};"
connection_string << "Trusted_Connection=Yes;"
connection = WIN32OLE.new('ADODB.Connection')

-- 
Posted via http://www.ruby-forum.com/.