hi Bob, Go through this url this will be helpful for you.
http://github.com/rails-sqlserver/activerecord-sqlserver-adapter/wiki/Platform-Installation---Windows On Tue, Nov 2, 2010 at 8:40 PM, Bob <[email protected]> wrote: > 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]<rubyonrails-talk%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- Thanks & Regards, MuraliDharaRao.T +91-9642234646 -- 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.
