From: jdonnell <jaydonnell@...>
Date: 2005-08-30T01:56:24+09:00
Subject: Re: mssql ado problems

I tried that and got

c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:135:in `execute': Execute
(DBI::DatabaseError)
    OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server

      Cannot create new connection because in manual or distributed
transaction mode.

///////////////////////////////////////////////////////////////////
code
///////////////////////////////////////////////////////////////////

require 'dbi'

# connect to a datbase
dbh = DBI.connect('DBI:ADO:Provider=SQLOLEDB; Data Source = localhost;
Initial Catalog = xx; User Id = xx; Password = xxxx;')
db2 = DBI.connect('DBI:ADO:Provider=SQLOLEDB; Data Source = localhost;
Initial Catalog = xx; User Id = xx; Password = xxxx;')
sth=dbh.prepare("select * from tblProductAttributeValues where
ProductAttributeID = '38'")
sth.execute

while row=sth.fetch do
  id = row[0]
  puts id

  tmp = dbh2.prepare("select top 5 * from tblDiamonds")
  tmp.execute
end

dbh.disconnect
gets