From: Masaki Suketa <masaki.suketa@...>
Date: 2006-08-02T20:26:01+09:00
Subject: Re: Using Win32OLE library for DAO

Hello, 
In message "Using Win32OLE library for DAO"
    on 06/08/01, "Jatinder Singh" <jatinder.saundh@gmail.com> writes:

> I am trying to do something like following to connect to a MS Access db from
> ruby
> db = WIN32OLE.*new*("DAO.Database")
> 
> but it gives me an error  "accessQuery.rb:17:in `initialize': unknown OLE
> server: `DAO.Database' (WIN32OLER
> untimeError)"
> How can I use DAO object library from ruby?

I have not used DAO, but I hope that DAO.DBEngine is what you want.

  require 'win32ole'
  WIN32OLE_TYPE.progids.each do |p|
    if /dao/i =~ p
      puts p
    end
  end

In my win2k box, the result of above script is:
  DAO.DBEngine.36
  DAO.PrivateDBEngine.36
  DAO.TableDef.36
  DAO.Field.36
  ...

And
  require 'win32ole'
  dao = WIN32OLE.new('DAO.DBEngine.36')
works fine.

  Regards,
  Masaki Suketa