Rails and SQL Server
March 1st, 2006 by papillon
This page include almost everything you need to get started with SQL Server (2005): HowtoConnectToMicrosoftSQLServer
Basically, you have to copy the file ADO.rb from the latest Ruby-DBI source distribution to the directory
ruby\\lib\\ruby\\site_ruby\\1.8\\DBD\\ADO
and then set up your database.yml like this:
development: adapter: sqlserver database: mydb host: myhost username: myuser password: mypassword