From: Patrick Spence <djmj12@...>
Date: 2006-11-13T23:21:11+09:00
Subject: Re: Ruby and COM


Aureliano Buendia wrote:
> Hi,
>
> Is it possible to use a COM component library in Ruby? The COM consists
> of a dll and a tlb file, it is NOT a .NET assembly, just a standard
> windows COM.
>
> --
> Posted via http://www.ruby-forum.com/.
Yes. For example...

require 'win32ole'

begin

  oCn = WIN32OLE.new("adodb.connection")
  oCn.connectionString = "Provider=sqloledb;Data Source=(local);Initial
Catalog="northwind";Integrated Security=sspi;"

  oCn.open()
  puts("Connection opened to Northwind database")

rescue Exeception => ex
  puts(ex.message())

ensure

  oCn.close() unless oCn.nil?
  oCn = nil

end