Hi, We are trying to connect an app that was using postgre to use MS SQL Server on a Centos 6 oracle virtualbox vm.
We have installed the activerecord-sqlserver-adapter and tiny_tds gems packages. The list of gems installed for this app are shown below.
actionmailer (4.0.1) actionpack (4.0.1) activemodel (4.1.4, 4.0.1) activerecord (4.1.4, 4.0.1) activerecord-deprecated_finders (1.0.3) activerecord-sqlserver-adapter (4.1.0, 4.0.0) activesupport (4.1.4, 4.0.1) arel (5.0.1.20140414130214, 4.0.1) atomic (1.1.14) bcrypt-ruby (3.1.2) bigdecimal (1.1.0) bitters (0.9.1) bourbon (3.1.8) builder (3.1.4) bundler (1.6.5) bundler-unload (1.0.2) coffee-rails (4.0.1) coffee-script (2.2.0) coffee-script-source (1.6.3) devise (3.2.2) erubis (2.7.0) execjs (2.0.2) executable-hooks (1.3.2) font-awesome-sass (4.0.2) gem-wrappers (1.2.5) haml (4.0.4) hike (1.2.3) i18n (0.6.11, 0.6.5) io-console (0.3) jbuilder (1.5.2) jquery-rails (3.0.4) json (1.8.1, 1.5.5) libv8 (3.16.14.3) mail (2.5.4) mime-types (1.25) minitest (5.4.0, 4.7.5, 2.5.1) multi_json (1.8.2) neat (1.4.0) orm_adapter (0.5.0) pg (0.17.1) polyglot (0.3.3) rack (1.5.2) rack-test (0.6.2) rails (4.0.1) rails_12factor (0.0.2) rails_serve_static_assets (0.0.1) rails_stdout_logging (0.0.3) railties (4.0.1) rake (10.1.0, 0.9.2.2) rdoc (3.12.2, 3.9.5) ref (1.0.5) rubygems-bundler (1.4.4) rvm (1.11.3.9) sass (3.2.12) sass-rails (4.0.1) sdoc (0.3.20) sprockets (2.10.0) sprockets-rails (2.0.1) therubyracer (0.12.1) thor (0.18.1) thread_safe (0.1.3) tilt (1.4.1) tiny_tds (0.6.2) treetop (1.4.15) turbolinks (1.3.1) tzinfo (1.2.1, 0.3.38) uglifier (2.3.1) warden (1.2.3)
Our database.yml file has the following.
development: adapter: sqlserver database: rubydemo user: User1 dataserver: machine.domain.local port: 1433 password: dsfsdfsdfsf
when we telnet to the sql server machine.domain.local on port 1433, it responds as does a ping, so the port and network seem to work.
We get the errors below when doing rake db:setup
Any ideas what we might be missing or what we can try.
Thanks Lance
(in /var/www/html/rubydemo) DEPRECATION WARNING: This database tasks were deprecated, because this tasks should be served by the 3rd party adapter. (called from mon_synchronize at /usr/local/rvm/rubies/ruby-1.9.3-p547/lib/ruby/1.9.1/monitor.rb:211) sorry, your database adapter is not supported yet, feel free to submit a patch rake aborted! Adaptive Server connection failed /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/tiny_tds-0.6.2/lib/tiny_tds/client.rb:77:in `connect' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/tiny_tds-0.6.2/lib/tiny_tds/client.rb:77:in `initialize' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-sqlserver-adapter-4.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:287:in `new' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-sqlserver-adapter-4.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:287:in `dblib_connect' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-sqlserver-adapter-4.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:276:in `connect' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-sqlserver-adapter-4.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:62:in `initialize' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-sqlserver-adapter-4.0.0/lib/active_record/sqlserver_base.rb:17:in `new' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-sqlserver-adapter-4.0.0/lib/active_record/sqlserver_base.rb:17:in `sqlserver_connection' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:440:in `new_connection' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:450:in `checkout_new_connection' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:421:in `acquire_connection' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:356:in `block in checkout' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:355:in `checkout' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:265:in `block in connection' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:264:in `connection' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:546:in `retrieve_connection' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/connection_handling.rb:79:in `retrieve_connection' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/connection_handling.rb:53:in `connection' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/migration.rb:611:in `connection' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/migration.rb:624:in `block in method_missing' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/migration.rb:597:in `block in say_with_time' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/migration.rb:597:in `say_with_time' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/migration.rb:617:in `method_missing' /var/www/html/rubydemo/db/schema.rb:17:in `block in <top (required)>' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/schema.rb:42:in `instance_eval' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/schema.rb:42:in `define' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/schema.rb:62:in `define' /var/www/html/rubydemo/db/schema.rb:14:in `<top (required)>' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activesupport-4.0.1/lib/active_support/dependencies.rb:223:in `load' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activesupport-4.0.1/lib/active_support/dependencies.rb:223:in `block in load' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activesupport-4.0.1/lib/active_support/dependencies.rb:214:in `load_dependency' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activesupport-4.0.1/lib/active_support/dependencies.rb:223:in `load' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/railties/databases.rake:253:in `block (3 levels) in <top (required)>' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/gems/activerecord-4.0.1/lib/active_record/railties/databases.rake:260:in `block (3 levels) in <top (required)>' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/bin/ruby_executable_hooks:15:in `eval' /usr/local/rvm/gems/ruby-1.9.3-p547@onlife-ruby-demo/bin/ruby_executable_hooks:15:in `<main>' Tasks: TOP => db:schema:load (See full trace by running task with --trace)
