From: Aemca <none@...>
Date: 2005-11-04T23:27:09+09:00
Subject: Re: MS SQL Access from Ruby in Windows


"Dave Burt" <dave@burt.id.au> wrote in message 
news:LoJaf.8659$Hj2.184@news-server.bigpond.net.au...
> 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

ODBC isn't really a good way to connect to an access database.
ADO blows it out of the boat performance and quirk wise.