Connecting ActiveRecord to SQLServer using the activerecord-sqlserver-adapter

Install the Ruby Development Kit - [http://wiki.github.com/oneclick/rubyinstaller/development-kit] (http://wiki.github.com/oneclick/rubyinstaller/development-kit)

• ruby-odbc needs a C compiler, so this needs to be completed first.
• Be sure to follow the steps here to install the dev kit - [https://github.com/oneclick/rubyinstaller/wiki/development-kit] (https://github.com/oneclick/rubyinstaller/wiki/development-kit)

gem install ruby-odbc

gem install activerecord-sqlserver-adapter - [https://github.com/rails-sqlserver/activerecord-sqlserver-adapter] (https://github.com/rails-sqlserver/activerecord-sqlserver-adapter)

Create system ODBC Data Sources for each environment - [http://msdn.microsoft.com/en-us/library/ms714024(VS.85).aspx] (http://msdn.microsoft.com/en-us/library/ms714024(VS.85).aspx)