Using rails-sqlserver-2000-2005-adapter on Windows

This is a different approach to my previous post Using SQL Server in Rails 2
Now I am using Rails 2.2.2 on Windows and the Rails SQL Server 2000-2005 adapter. Additionally I am using ODBC, because ADO support seems to be deprecated.
The installation is straightforward as explained on the adapter github page:

Since we are using ODBC [...]

Using SQL Server in Rails 2

These are the steps to access a SQL Server database from a Rails 2.0 application running on Windows.
The SQL Server adapter is not incuded by default in Rails 2. It is necessary to download and install it using the following command.

gem install activerecord-sqlserver-adapter
–source=http://gems.rubyonrails.org

Download the latest version of ruby-dbi from
http://rubyforge.org/projects/ruby-dbi/
and then extract the file [...]

Books I am reading now

The international shipping rates are usually more expensive than the books, so I am reading the following books in PDF…

TextMate, Power Editing for the Mac
Agile Web Development with Rails—Second Edition
Pragmatic Version Control using Subversion 2nd Ed.
Learn to Program
Behind Closed Doors
Programming Ruby (2nd. Ed.)
Pragmatic Unit Testing in C# 2nd Ed.
Beginning Ruby: From Novice to Professional
Smart [...]

Excuse me for my english

I’ve thinking about which language to use in this blog. My native language is Spanish, however I believe that I can have more audience if I publish in English. Obviously my English is not as good as I’d like so please forgive me for any errors. I’ll try to do my best effort.

Please let me [...]