From: Ruby Mania <prateek123@...>
Date: 2010-10-23T07:16:08+09:00
Subject: Re: Database connection String Using 'win32ole'

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/.