rails 와 sqlserver 연결이 안됍니다.

rails를 이용하여 프로그램 환경을 구축중에 벌써 3일째 해결을 못하고 있습니다.

1, 시스템 환경
OS : windows7 64bit
DBMS : SQL Server 2008
Ruby version : 1.8.7 (i386-mingw32)
RubyGems version : 1.8.24
Rack version : 1.4
Rails version : 3.2.8
Active Record version : 3.2.8
Action Pack version : 3.2.8
Active Support version :3.2.8
activerecord-sqlserver-adapter : 3.2.9

입니다.

2. Activerecord directory
activerecord : ~\Ruby187\lib\ruby\gems\1.8\gems\activerecord-3.2.8
activerecord sqlserver : ~\Ruby187\lib\ruby\gems\1.8\gems\activerecord-sqlserver-adapter-3.2.9

sqlserver adapter는 별도의 디렉토리로 생기더군요

3. gem file 설정

#group :development do
gem 'sql_server'
gem 'execjs'
#end

group :development, :test do
gem 'therubyracer', :platforms => :ruby
end

# Gems used only for assets and not required
# in production environments by default.
group :assets do
gem 'sass-rails', '3.2.4'
gem 'coffee-rails', '3.2.2'

# See https://github.com/sstephenson/execjs#readme for more supported runtimes
# gem 'therubyracer', :platforms => :ruby

gem 'uglifier', '>= 1.2.3'
end

gem 'jquery-rails'

4. database.yml 설정

# SQLServer 2008
#development:
# adapter: sqlserver
# mode: odbc
# username: sa
# password: 11
# dsn: rubyado
# database: photos_development
# timeout: 5000

development:
adapter: sqlserver
#mode: ado
mode: odbc
dsn: sqlserverapp
# dsn: first_app
host: localhost
database: first_app
username: sa
password: 11
# port: 1433
# azure: true

입니다.

5. Error 로그

ActiveRecord::ConnectionNotEstablished (ActiveRecord::ConnectionNotEstablished):

activerecord (3.2.8) lib/active_record/connection_adapters/abstract/connection
_pool.rb:404:in `retrieve_connection'
activerecord (3.2.8) lib/active_record/connection_adapters/abstract/connection
_specification.rb:170:in `retrieve_connection'
activerecord (3.2.8) lib/active_record/connection_adapters/abstract/connection
_specification.rb:144:in `connection'
activerecord (3.2.8) lib/active_record/query_cache.rb:67:in `call'
activerecord (3.2.8) lib/active_record/connection_adapters/abstract/connection
_pool.rb:473:in `call'
actionpack (3.2.8) lib/action_dispatch/middleware/callbacks.rb:28:in `call'
activesupport (3.2.8) lib/active_support/callbacks.rb:405:in `_run__275737560_
_call__4__callbacks'
activesupport (3.2.8) lib/active_support/callbacks.rb:405:in `send'
activesupport (3.2.8) lib/active_support/callbacks.rb:405:in `__run_callback'
activesupport (3.2.8) lib/active_support/callbacks.rb:385:in `_run_call_callba
cks'
activesupport (3.2.8) lib/active_support/callbacks.rb:81:in `send'
activesupport (3.2.8) lib/active_support/callbacks.rb:81:in `run_callbacks'
actionpack (3.2.8) lib/action_dispatch/middleware/callbacks.rb:27:in `call'
actionpack (3.2.8) lib/action_dispatch/middleware/reloader.rb:65:in `call'
actionpack (3.2.8) lib/action_dispatch/middleware/remote_ip.rb:31:in `call'
actionpack (3.2.8) lib/action_dispatch/middleware/debug_exceptions.rb:16:in `c
all'
actionpack (3.2.8) lib/action_dispatch/middleware/show_exceptions.rb:56:in `ca
ll'
railties (3.2.8) lib/rails/rack/logger.rb:26:in `call_app'
railties (3.2.8) lib/rails/rack/logger.rb:16:in `call'
actionpack (3.2.8) lib/action_dispatch/middleware/request_id.rb:22:in `call'
rack (1.4.1) lib/rack/methodoverride.rb:21:in `call'
rack (1.4.1) lib/rack/runtime.rb:17:in `call'
activesupport (3.2.8) lib/active_support/cache/strategy/local_cache.rb:72:in `
call'
rack (1.4.1) lib/rack/lock.rb:15:in `call'
actionpack (3.2.8) lib/action_dispatch/middleware/static.rb:62:in `call'
railties (3.2.8) lib/rails/engine.rb:479:in `call'
railties (3.2.8) lib/rails/application.rb:223:in `call'
rack (1.4.1) lib/rack/content_length.rb:14:in `call'
railties (3.2.8) lib/rails/rack/log_tailer.rb:17:in `call'
rack (1.4.1) lib/rack/handler/webrick.rb:59:in `service'
D:/ruby_projcet/Ruby187/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
D:/ruby_projcet/Ruby187/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
D:/ruby_projcet/Ruby187/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
D:/ruby_projcet/Ruby187/lib/ruby/1.8/webrick/server.rb:162:in `start'
D:/ruby_projcet/Ruby187/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
D:/ruby_projcet/Ruby187/lib/ruby/1.8/webrick/server.rb:95:in `start'
D:/ruby_projcet/Ruby187/lib/ruby/1.8/webrick/server.rb:92:in `each'
D:/ruby_projcet/Ruby187/lib/ruby/1.8/webrick/server.rb:92:in `start'
D:/ruby_projcet/Ruby187/lib/ruby/1.8/webrick/server.rb:23:in `start'
D:/ruby_projcet/Ruby187/lib/ruby/1.8/webrick/server.rb:82:in `start'
rack (1.4.1) lib/rack/handler/webrick.rb:13:in `run'
rack (1.4.1) lib/rack/server.rb:265:in `start'
railties (3.2.8) lib/rails/commands/server.rb:70:in `start'
railties (3.2.8) lib/rails/commands.rb:55
railties (3.2.8) lib/rails/commands.rb:50:in `tap'
railties (3.2.8) lib/rails/commands.rb:50
script/rails:6:in `require'
script/rails:6

입니다.

>> 어떻게 하면 위 문제를 해결할 수 있을까요?