From: mully <david.mullet@...>
Date: 2006-11-11T12:55:05+09:00
Subject: Re: MS SQL direct access



On Nov 10, 9:14 pm, johnf <jfabi...@yolo.com> wrote:
> Just wondering if Ruby can access MS SQL2000 direct - not using ODBC.
>
> John

Using the win32ole module (on Windows), you can access Microsoft SQL
Server databases via the ADODB object model.

Incomplete example:

cn = WIN32OLE.new('ADODB.Connection')
cn.Open(...)
rs = WIN32OLE.new('ADODB.Recordset')
rs.Open(...)

Mully