From: David Naseby <dnaseby@...>
Date: 2001-01-10T12:22:25+09:00
Subject: [ruby-talk:8976] Re: Database access with ADO

Thanks for the quick response, but I tried this code
> From: Ernest Ellingson [mailto:erne@powernav.com]
> require 'win32ole'
> oConn=WIN32OLE.new('ADODB.Connection')
> oConn.ConnectionString="DSN=xxxxx;uid=xxxx;pwd=xxxx"
> oConn.Open
> rs=oConn.Execute("SQLString")

(of course, substituting the xxxxx and SQLString), and I got the following
error:
ado2.rb:4:in 'method missing': Open (RuntimeError)
    OLE rb_compile_error:80004005 in Microsoft OLE DB Provider for ODBC
Drivers
    [Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
Exception occurred
        from ado2.rb:4

The code worked (with the usual conversions) in a VBScript file.

David Naseby