Hi all, i''m beginner in rails world...i try to connect my rails application on a db sql server 6.5 without success, ca you help me? i try odbc driver, jtds e activerecord-sqlserver-adapter but nothing... what are the right gems or the right sequence procedure? thx Prinx -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
I only know about SQLServer 2005 and 2008, not 6.5. Anyway, here is a list of things I had to do to get a project working with 2005 using Ruby 1.8.6, Rails 2.3.5 and Mongrel as the web server. You might need to skip/change some of the steps. I hope it helps: 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 authentication gem: gem install authlogic 9. Install encryption gem: gem install attr_encrypted 10. Install SQL Server Management utility (from Microsoft) 11. Create SQL Server DB 12. Create login in SQL Server 13. Create DB user 14. 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: *Give it a name* ii. Description: *Give it a description* iii. Server: Server name (*whatever name you can see in the SQL Server Management Utility*) iv. Use SQL Authentication On Oct 4, 5:11 pm, prinx <s.princio...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi all, > i''m beginner in rails world...i try to connect my rails application on > a db sql server 6.5 without success, ca you help me? > i try odbc driver, jtds e activerecord-sqlserver-adapter but > nothing... > what are the right gems or the right sequence procedure? > > thx > Prinx-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
Forgot to add database.yml configuration. Here it is: your_environment_here: adapter: sqlserver mode: odbc dsn: your_dsn_name_here username: your_username_here password: your_password_here There is no need to use host or port parameter since we''re using a DSN. On Oct 5, 8:40 am, pepe <P...-1PhG29ZdMB/g+20BJ0uB2w@public.gmane.org> wrote:> I only know about SQLServer 2005 and 2008, not 6.5. Anyway, here is a > list of things I had to do to get a project working with 2005 using > Ruby 1.8.6, Rails 2.3.5 and Mongrel as the web server. You might need > to skip/change some of the steps. I hope it helps: > > 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 authentication gem: gem install authlogic > 9. Install encryption gem: gem install attr_encrypted > 10. Install SQL Server Management utility (from Microsoft) > 11. Create SQL Server DB > 12. Create login in SQL Server > 13. Create DB user > 14. 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: *Give it a name* > ii. Description: *Give it a description* > iii. Server: Server name (*whatever name you can see in the SQL > Server Management Utility*) > iv. Use SQL Authentication > > On Oct 4, 5:11 pm, prinx <s.princio...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Hi all, > > i''m beginner in rails world...i try to connect my rails application on > > a db sql server 6.5 without success, ca you help me? > > i try odbc driver, jtds e activerecord-sqlserver-adapter but > > nothing... > > what are the right gems or the right sequence procedure? > > > thx > > Prinx-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
Ok, i''ll try yours advice, i hope to do it... I will let you know :-) Thank''s Prinx On 6 Ott, 14:51, pepe <P...-1PhG29ZdMB/g+20BJ0uB2w@public.gmane.org> wrote:> Forgot to add database.yml configuration. Here it is: > > your_environment_here: > adapter: sqlserver > mode: odbc > dsn: your_dsn_name_here > username: your_username_here > password: your_password_here > > There is no need to use host or port parameter since we''re using a > DSN. > > On Oct 5, 8:40 am, pepe <P...-1PhG29ZdMB/g+20BJ0uB2w@public.gmane.org> wrote: > > > I only know about SQLServer 2005 and 2008, not 6.5. Anyway, here is a > > list of things I had to do to get a project working with 2005 using > > Ruby 1.8.6, Rails 2.3.5 and Mongrel as the web server. You might need > > to skip/change some of the steps. I hope it helps: > > > 1. Install Ruby (1.8.6):http://www.ruby-lang.org/en/downloads/ > > 2. Install rubygems: > > a. http://rubygems.org/pages/download(zipversion) > > 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 authentication gem: gem install authlogic > > 9. Install encryption gem: gem install attr_encrypted > > 10. Install SQL Server Management utility (from Microsoft) > > 11. Create SQL Server DB > > 12. Create login in SQL Server > > 13. Create DB user > > 14. 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: *Give it a name* > > ii. Description: *Give it a description* > > iii. Server: Server name (*whatever name you can see in the SQL > > Server Management Utility*) > > iv. Use SQL Authentication > > > On Oct 4, 5:11 pm, prinx <s.princio...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > Hi all, > > > i''m beginner in rails world...i try to connect my rails application on > > > a db sql server 6.5 without success, ca you help me? > > > i try odbc driver, jtds e activerecord-sqlserver-adapter but > > > nothing... > > > what are the right gems or the right sequence procedure? > > > > thx > > > Prinx-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.