From: Raj pal <lists@...>
Date: 2013-04-05T18:40:25+09:00
Subject: Re: question on watir

Yes thank you, this is what I expected.

Another question,

I am using ADODBconnector for exatracting the data from spread sheet, 
here I am getting an error.

14:56:56] [ERROR] : Open
    OLE error code:80004005 in Microsoft JET Database Engine
      The connection for viewing your linked Microsoft Excel worksheet 
was lost.
    HRESULT error code:0x80020009

it shows the error in the below line.

 def query(sql)
    recordset = WIN32OLE.new('ADODB.Recordset')
---------->    recordset.Open(sql, connection)#this line it indicates.
    @data = recordset.GetRows.transpose
    @fields = []
    recordset.Fields.each do |field|
      @fields << field.Name
    end
  end

Do you have any idea ?

-- 
Posted via http://www.ruby-forum.com/.