Currently try to get rails support for sql server 2005. -
i looking make rails application pulling requests sql server 2005. hard install needed drivers using following commands
gem install activerecord -v 3.2.0 gem install activerecord-sqlserver-adapter -v 3.2.0
now set yml file follows.
development: <<: *default host: 192.168.1.160 adapter: sqlserver mode: odbc dsn: ierp85_dev database: ierp85_dev username: name password: pass
now run server uncover message
could not load 'active_record/connection_adapters/sqlserver_adapter'. make sure adapter in config/database.yml valid. if use adapter other 'mysql', 'mysql2', 'postgresql' or 'sqlite3' add necessary adapter gem gemfile.
i go gem file , add line
gem 'activerecord-sqlserver-adapter', '~> 3.2.0' bundle install in gemfile: activerecord-sqlserver-adapter (~> 3.2.0) x86-mingw32 depends on activerecord (~> 3.2.0) x86-mingw32 rails (= 4.1.8) x86-mingw32 depends on activerecord (4.1.8)
i tried update no luck. how know using active record 3.2.0 gem install above? cannot upgrade server 2012.
since appear using rails 4.1 need use version 4.1.x of adapter. luckily claims support sql server 2005.
update gemfile
gem 'activerecord-sqlserver-adapter', '~> 4.1.0'
and things should work (in fact drop version constraint altogether since 4.1.x of adapter work rails 4.1)
Comments
Post a Comment