I''ve attached my database.yml I''ve installed gem install activerecord-sqlserver-adapter But when I navigate to a simple page I get the ActiveRecord::ConnectionNotEstablished error Any ideas what I should be checking? Ruby 1.92 Rails 3 Attachments: http://www.ruby-forum.com/attachment/5016/database.yml -- Posted via http://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 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''ve never used sqlserver before but I would start with the development.log file for clues. Assuming there is a command line client can you connect to the database with it? Can you ping your db host "mordor"? In dev the host is usually localhost (in linuxland anyway). On Sep 7, 12:30 pm, Bo Pritchard <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> I''ve attached my database.yml > I''ve installed gem install activerecord-sqlserver-adapter > > But when I navigate to a simple page I get the > ActiveRecord::ConnectionNotEstablished error > > Any ideas what I should be checking? > > Ruby 1.92 > Rails 3 > > Attachments:http://www.ruby-forum.com/attachment/5016/database.yml > > -- > 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 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.
try conecty with irb use ActiveRecord::Base.establish_conection( hash_here) the hash for MS SQL server is {:adapter =>"sqlserver", :mode=> "ado", :database=>"db name here", :host=> "host_here" } you need to be able to resolve the host from the machine if you use a name On Tue, Sep 7, 2010 at 12:30 PM, Bo Pritchard <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> I''ve attached my database.yml > I''ve installed gem install activerecord-sqlserver-adapter > > But when I navigate to a simple page I get the > ActiveRecord::ConnectionNotEstablished error > > Any ideas what I should be checking? > > Ruby 1.92 > Rails 3 > > Attachments: > http://www.ruby-forum.com/attachment/5016/database.yml > > -- > Posted via http://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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- 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.
Tony Primerano wrote:> I''ve never used sqlserver before but I would start with the > development.log file for clues. > > Assuming there is a command line client can you connect to the > database with it? Can you ping your db host "mordor"? In dev the > host is usually localhost (in linuxland anyway).yep, i can ping it and connect via command line fine. i checked the development.log and didn''t see anything of interest. -- Posted via http://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 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.