Loading the ActiveRecord SQL Server adapter in a Rails 2.1 app
It’s pretty simple. In your config/environment.rb: config.gem 'activerecord-sqlserver-adapter', :source => 'http://gems.rubyonrails.org', :lib => 'active_record/connection_adapters/sqlserver_adapter'
Then run rake gems:install and away you go.
Hugh has some more tips about the packages and configuration required to connect to an SQL Server from a Linux platform.