ActiveRecord::ConnectionNotEstablished error

Rails
1

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

2

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).

3

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

4

Tony P. 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.