Rails通过activerecord适配器连接到sqlserver 2008

Question

我下载了BitNami的Jruby。一切都很好，但是当我想连接到Server 2008时，有些地方出了问题。

database.yml如下所示

development:
       adapter: sqlserver
      host: 127.0.0.1
      instanceName: SQLServer2008
      database: truetemp
      username: sa
      password: 7354500

我使用命令"Jruby生成脚手架产品标题:string.“，ROR运行良好；但是命令"rake：-S -跟踪”失败。

f:\tmp\RubyMine201207>rake db:迁移--跟踪**调用db:迁移(first_time) **调用环境(first_time) **执行环境**调用db:load_config (first_time) **调用rails_env (first_time) **执行rails_env **执行db:load_config rake中止！请安装sqlserver适配器：gem install activerecord-sqlserver-adapte r (没有要加载的文件-gem install activerecord-sqlserver-adapte r) org/jruby/RubyKernel.java:1033:in require' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activesupport-3 .2.1/lib/active_support/dependencies.rb:251:inrequire‘F:/Program /BitNami .2.1/lib/active_support/dependencies.rb:236:in load_dependency' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activesupport-3 .2.1/lib/active_support/dependencies.rb:251:inload_dependency' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activesupport-3 .2.1/lib/active_support/dependencies.rb:251:in’F:/Program /BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract/connection_specification.rb:4 8：resolve_hash_connection' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activerecord-3. 2.1/lib/active_record/connection_adapters/abstract/connection_specification.rb:3 9:inresolve_string_connection‘F:/Program /BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/connection_adapters/abstract/connection_specification.rb:2 3:in spec' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activerecord-3. 2.1/lib/active_record/connection_adapters/abstract/connection_specification.rb:1 27:inestablish_connection‘F:/Program /BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/railtie.rb:76:in Railtie' org/jruby/RubyKernel.java:2045:ininstance_eval‘F:/Program /BitNami .2.1/lib/active_support/lazy_load_hooks.rb:36:in execute_hook' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activesupport-3 .2.1/lib/active_support/lazy_load_hooks.rb:43:inrun_load_hooks’org/jruby/RubyArray.java:1615:in each' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activesupport-3 .2.1/lib/active_support/lazy_load_hooks.rb:42:inrun_load_hooks‘F:/Program /BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activerecord-3.2.1/lib/active_record/base.rb:716:in (root)' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/activerecord-3. 2.1/lib/active_record/base.rb:6:in(Root)org/jruby/RubyProc.java:270：call' org/jruby/RubyProc.java:220:in call‘F:/Program /BitNami b/rake/task.rb:205:在execute' org/jruby/RubyArray.java:1615:in中: F:/Program /BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/task.rb:200:in execute' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/task.rb:158:ininvoke_with_call_chain‘F:/Program /BitNami mon_sy nchronize' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/task.rb:151:ininvoke_with_call_chain’F:/Program /BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/task.rb:176:在invoke_prerequisites' org/jruby/RubyArray.java:1615:in中：:/Program /BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/task.rb:174:in invoke_prerequisites' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/task.rb:157:ininvoke_with_call_chain‘F:/Program /BitNami JRubyStack/jruby/lib/ruby/1.8/monitor.rb:191:in mon_sy nchronize' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/task.rb:151:ininvoke_with_call_chain’F:/Program /BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/task.rb:144:在invoke' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/application.rb:116:ininvoke_task‘F:/Program /BitNami b/rake/application.rb .94:94：top_level' org/jruby/RubyArray.java:1615:in中每一个’F:/Program /BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/application.rb：94:在JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li top_level' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/application.rb:133:instandard_exception_handling‘F:/Program /BitNami b/rake/application.rb.run:88:in top_level' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/application.rb:66:inrun’F:/Program /BitNami b/rake/application.rb.run:133:in standard_exception_handling' F:/Program Files/BitNami JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/li b/rake/application.rb:63:inrun‘F:/Program /JRubyStack/jruby/lib/ruby/gems/1.8/gems/rake-0.9.2.2/bi n/rake:33:in (root)' org/jruby/RubyKernel.java:1058:inload‘F:/Program / BitNami JRubyStack/jruby/bin/rake:23:in (BitNami)任务:BitNami => db:迁移=> db:load_config

Answer 1

确保将以下行添加到Gemfile中

gem 'activerecord-sqlserver-adapter'