development: adapter: "sqlserver" mode: "odbc" host: "localhost" username: "mssql_user" password: "mssql_password" database: "database name" dataserver: "Server name" dsn: "mssql dsn" # 「コントロールパネル」 => 「ODBCデータソースアドミニストレータ」 で接続先のDBへのDSNを作成します。 # coding:utf-8 require "rubygems" require "activerecord-sqlserver-adapter" require "odbc" require "yaml" require "logger" @setting = YAML::load(File.open("da
![ActiveRecordでSQLServerへ接続する - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/fa5e2ea5de2560eafb8cbf5571d384bd48734704/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fcdn.qiita.com%252Fassets%252Fpublic%252Farticle-ogp-background-412672c5f0600ab9a64263b751f1bc81.png%3Fixlib%3Drb-4.0.0%26w%3D1200%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTk3MiZoPTM3OCZ0eHQ9QWN0aXZlUmVjb3JkJUUzJTgxJUE3U1FMU2VydmVyJUUzJTgxJUI4JUU2JThFJUE1JUU3JUI2JTlBJUUzJTgxJTk5JUUzJTgyJThCJnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnR4dC1jb2xvcj0lMjMyMTIxMjEmdHh0LWZvbnQ9SGlyYWdpbm8lMjBTYW5zJTIwVzYmdHh0LXNpemU9NTYmcz1mMjFiYTM0NWFlYTc4ZTJhM2IyYWRlZTk3ZmRmNjQ3NA%26mark-x%3D142%26mark-y%3D57%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZoPTc2Jnc9NzcwJnR4dD0lNDBqYWNveXV0b3JpdXMmdHh0LWNvbG9yPSUyMzIxMjEyMSZ0eHQtZm9udD1IaXJhZ2lubyUyMFNhbnMlMjBXNiZ0eHQtc2l6ZT0zNiZ0eHQtYWxpZ249bGVmdCUyQ3RvcCZzPTNhNTE3NmQ3YTk0MWNlMWJjOTY5NDNhYzdmOGU1MGU5%26blend-x%3D142%26blend-y%3D486%26blend-mode%3Dnormal%26s%3D1cd122ec3788171282cf05cd7389ed15)