Yeah, I know. But hey, sometimes you gotta live on the edge.
If you don’t already have ODBC talking to MS SQL Server on your Mac, you’ll need to get that set up and tested first.
We need a couple of extra pieces of software to let Rails talk to the server via ODBC.
Ruby-ODBC:
cd /tmp
wget http://www.ch-werner.de/rubyodbc/ruby-odbc-0.996.tar.gz
tar vxzf ruby-odbc-0.996.tar.gz
cd ruby-odbc-0.996
ruby extconf.rb
make
sudo make install
Ruby DBI ODBC driver:
cd /tmp
wget http://rubyforge.org/frs/download.php/655/ruby-dbi-all-0.0.23.tar.gz
tar vxzf ruby-dbi-all-0.0.23.tar.gz
cd ruby-dbi-all
ruby setup.rb config --with=dbi,dbd_odbc
ruby setup.rb setup
sudo ruby setup.rb install
The format of the database.yml will be slightly different than the norm:
development:
adapter: sqlserver
mode: odbc
dsn: the_dsn_you_created_and_tested_in_iodbc_administrator
username: username
password: password
There is currently a bug in script/console that will throw a BUS error when trying to access the database, but everything works outside of the console.
You should also be aware that SQL Server isn’t currently supported very well in Rails. I ran into a couple of bugs today and submitted patches for them: