From: Graham Brooks <graham.brooks@...4all.co.uk>
Date: 2001-07-26T07:19:09+09:00
Subject: [ruby-talk:18547] Problems calling a VB COM object

I am trying to script some COM tests using Ruby and WIN32OLE. I am new to
Ruby and so may be missing something obvious.

The smallest script that advertises the error is

require "win32ole"
o = WIN32OLE.new("ProgID")
rs = o.Method(51,2)

The method in question takes two Long parameters and returns an ADODB
Recordset object. When I run the code I get a Type Mismatch error. Simailar
code in other scripts calling the same method work fine. Checking the ole
methods of the object indicates that the object supports the method I am
calling.

Does anyone know why this should be going wrong?

Thanks in advance
Graham