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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
