These are chat archives for rails-sqlserver/activerecord-sqlserver-adapter

Aug 2016
Nguyễn Bảo Thi
Aug 23 2016 07:14
hi all
plz @metaskills i do connet it ok but when i run localhost:300 it error`
rails s
=> Booting WEBrick
=> Rails application starting in development on http://localhost:3000
=> Run `rails server -h` for more startup options
=> Ctrl-C to shutdown server
[2016-08-23 14:10:33] INFO  WEBrick 1.3.1
[2016-08-23 14:10:33] INFO  ruby 2.3.1 (2016-04-26) [x86_64-linux]
[2016-08-23 14:10:33] INFO  WEBrick::HTTPServer#start: pid=6781 port=3000

Started GET "/" for at 2016-08-23 14:10:51 +0700

TinyTds::Error (Unable to connect: Adaptive Server is unavailable or does not exist):
  tiny_tds (0.6.2) lib/tiny_tds/client.rb:77:in `connect'
  tiny_tds (0.6.2) lib/tiny_tds/client.rb:77:in `initialize'
plz help me why do i run it error here
Nguyễn Bảo Thi
Aug 23 2016 07:22
default: &default
  adapter: sqlserver
  encoding: utf8
  reconnect: false
  username: sa
  password: Nanoco10
  port: 1433
  timeout: 25

  <<: *default
  database: N_PILOT
Ken Collins
Aug 23 2016 11:54
Always break down your issue to the simpliest debug. In this case, you want to test which TinyTDS connection options to use from something like an IRB prompt. Please use these docs for examples.
Also do some simple networking QA. Like make sure the host/port is reachable from your development machine. Port scan, etc.
Lastly, maybe use host vs dataserver.