ruby-on-rails - 如何在 Rails 中使用 rake 任务连接到 SQL Server？

Question

我尝试使用 ActiveRecord sqlserver 适配器连接到远程 SQL Server View :

@connection = ActiveRecord::Base.establish_connection(
  :adapter => "sqlserver",
  :dsn => "rms",
  :hosts => "xxx.xxx.xx.xx",
  :database => "V_MLS_ECOMM_STORE_SOH",
  :ports => "1521",
  :username =>  "xxxxxx",
  :passwords => "xxxxxxx")

@connection.connected? 总是返回 false。

Answer 1

做这样的事情:

class LegacyTable < ActiveRecord::Base
  establish_connection({
    :adapter  => "sqlserver",
    :host     => "host",
    :username => "user",
    :password => "pass",
    :database => "dbname"
  })

引用:https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/issues/250