From: Alexey Verkhovsky <alex@...>
Date: 2005-11-04T17:27:32+09:00
Subject: Re: MS SQL Access from Ruby in Windows

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??
>
>I wrote a ruby script that Using unixODBC drivers and Ruby's dbi module can 
>easily connect to the MS SQL database, make queries, etc from my Linux 
>machine.
>
>Now I need to run the script from a windows machine so others non-linux users 
>can use my ruby script but I haven't found any tips on what I need to allow 
>MS SQL database connectivity from a windows machine.
>  
>
You need ADO driver for DBD. Here is how you get it into One-Click Ruby 
Installer.

QTE http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer

Get the latest source distribution of Ruby-DBI from: 
http://ruby-dbi.rubyforge.org/ and copy the file:

src/lib/dbd_ado/ADO.rb

to:

X:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb 

(you will need to create the ADO directory).

UNQTE

One-Click installer should probably include this driver.

AV