Ruby on Rails

I struggled with getting SQLServer to work with rails a couple years
ago.  I can't speak to how easy or hard it is to do recently (sounds
just as painful), but here are the steps for how I did it then...they
might help.  A note about step 2, at the time I used v0.1.0 of ruby-
dbi.  ADO.rb continued to be included up through v0.2.2 and ADO.rb
from that version should still work but I think they stopped
supporting ADO after that.  I know these steps work with SQLServer
2005, I'm curious to know if this also works with 2008.  Also, I seem
to remember this only working with Ruby 1.8.6.  I have since switched
database systems and haven't been motivated enough to figure out
SQLServer with newer code.

1.  Install SqlServer adapter gem activerecord-sqlserver-adapter
(Only works with v1.0.0)
2.  Download source distribution of Ruby-DBI from rubyforge.org/
projects/ruby-dbi/ (at the time, I used v0.1.0.
       -copy the file lib/dbd/ADO.rb to Ruby/lib/ruby/site_ruby/1.8/DBD/ADO/
ADO.rb
               database.yml file format:
               development:
                       adapter: sqlserver
                       database: database_name
                       host: server_name
                       username: user_name
                       password: password

Hope this helps,
Bob

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.