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:ininitialize’
/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:indblib_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:ininitialize’
/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:insqlserver_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:incheckout_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:inblock 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:inblock 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:inretrieve_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:inconnection’
/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:inblock 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:insay_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:inblock 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:indefine’
/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:inblock 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:inload’
/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:inblock (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’
Tasks: TOP => db:schema:load
(See full trace by running task with --trace)