Here is a series of steps that I had to go through in order to get SQLServer 2005 working for my needs. You might need to skip/replace some steps. I hope this helps you.
1. Install Ruby (1.8.6): http://www.ruby-lang.org/en/downloads/ 2. Install rubygems: a. http://rubygems.org/pages/download (zip version) b. Unpack to a directory and cd there c. ruby setup.rb 3. Install rails: gem install rails –v=2.3.5 4. Install mongrel: gem install mongrel 5. Install mongrel service: gem install mongrel_service 6. Install SQL Server adapter: gem install activerecord-sqlserver- adapter 7. Install ODBC gem: gem install odbc-rails 8. Install SQL Server Management utility (from Microsoft) 9. Create SQL Server DB 10. Create login in SQL Server 11. Create DB user 12. Create DSN in Windows: a. Control Panel -> Adminstrative Tasks -> Data Sources (ODBC) b. Click on System DSN -> Add c. Select type SQL Server i. Name: Whichever name you want to give it here. ii. Description: Your description here iii. Server: Server name (whichever is the server name you see in SQL Server Management utility) iv. Use SQL Authentication On Sep 14, 6:08 am, Deng Bin <[email protected]> wrote: > hi erevy one > i use ruby 1.8.7 ,rails is 2.2.2 > > fisrt get the latest source distribution of Ruby-DBI > from:http://rubyforge.org/projects/ruby-dbi/and copy the file: > rub-DBI is 0.2.2 > > lib/dbd/ADO.rb > > to: > > X:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb > > then i install > gem install activerecord-sqlserver-adapter -v=2.2.8 > > i run the server > > error is > establish_connection please install the sqlserver adapter gem install > activerecord-sqlserver-adapter > no such file to load active_record/connection_adapters/sqlserver_adapter > > then i copy sqlserver_adapter from ctiverecord-sqlserver-adapter-3.0.0 > to that palce > > but that another error > > active_support/dependencies.rb:442 in 'load_missing_constant' > uninitialized constant activedrecord::wrappenddatabaseException <name > error> > > Anyone hit this ? > > Regards, > /deng > -- > Posted viahttp://www.ruby-forum.com/. -- 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.
