connecting Rails app to SQL Server
21 views
Skip to first unread message
Lance L.
Jul 30, 2014, 2:41:19 PM7/30/14
to rubyonra...@googlegroups.com
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)
--
Posted via http://www.ruby-forum.com/.
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)
--
Posted via http://www.ruby-forum.com/.
Lance L.
Jul 30, 2014, 2:52:27 PM7/30/14
to rubyonra...@googlegroups.com
BTW, I get the same error even if I am using Ruby 2.1.2
Reply all
Reply to author
Forward
0 new messages