From: Dave Burt <dave@...>
Date: 2005-11-04T22:37:09+09:00
Subject: Re: MS SQL Access from Ruby in Windows

Alexey wrote:
> Horacio Sanson wrote:
>
>>Can someone point me where to learn how to access a MS SQL 2000 database 
>>server from within ruby in a Windows machine??
>>
> You need ADO driver for DBD. Here is how you get it into One-Click Ruby 
> Installer.

That's one way, but you don't need it. The Windows One-Click installer comes 
with DBI and the ODBC DBD already installed - you can use DBI/ODBC out of 
the box.

Make a DSN, say "foo", and

require 'dbi'
dbh = DBI.connect("dbi:odbc:foo")

and Bob's your uncle.

Cheers,
Dave