{"action":"created","issue":{"url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/249","repository_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds","labels_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/249/labels{/name}","comments_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/249/comments","events_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/249/events","html_url":"https://github.com/rails-sqlserver/tiny_tds/issues/249","id":120893654,"number":249,"title":"TinyTds::Error: Write to the server failed","user":{"login":"TigerMint","id":7897410,"avatar_url":"https://avatars.githubusercontent.com/u/7897410?v=3","gravatar_id":"","url":"https://api.github.com/users/TigerMint","html_url":"https://github.com/TigerMint","followers_url":"https://api.github.com/users/TigerMint/followers","following_url":"https://api.github.com/users/TigerMint/following{/other_user}","gists_url":"https://api.github.com/users/TigerMint/gists{/gist_id}","starred_url":"https://api.github.com/users/TigerMint/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TigerMint/subscriptions","organizations_url":"https://api.github.com/users/TigerMint/orgs","repos_url":"https://api.github.com/users/TigerMint/repos","events_url":"https://api.github.com/users/TigerMint/events{/privacy}","received_events_url":"https://api.github.com/users/TigerMint/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":15,"created_at":"2015-12-07T23:27:09Z","updated_at":"2016-02-07T18:15:10Z","closed_at":"2016-02-07T18:15:10Z","body":"I’ve setup tiny_tds for my Rails app on Windows and when trying to run rake db:migrate or any other commands, each time the same command would fail with either:\r\n\r\nrake aborted!\r\nTinyTds::Error: Write to the server failed\r\nC:/Ruby22-x64/lib/ruby/gems/2.2.0/gems/tiny_tds-0.7.0-x64-mingw32/lib/tiny_tds/client.rb:74:in `connect'\r\nOr,\r\nTinyTds::Error: Read from the server failed\r\n\r\nThe tiny_tds (and the FreeTds comes with it) does work when running \r\nClient = TinyTds::Client.new ( connection properties )\r\nClient.execute (some query)\r\n\r\nAlso tried installed the FreeTds for Windows and reinstalled tiny_tds with gem install tiny_tds -- --with-freetds-dir=C:\\freetds-0.95rc2.\r\n\r\nStill running into the same issue.\r\n\r\nAdditional info:\r\n\r\nDatabase.yml:\r\ndevelopment:\r\n  adapter: sqlserver\r\n  mode: dblib\r\n  host: servername.database.windows.net\r\n  database: databasename\r\n  pool: 5\r\n  timeout: 120000\r\n  port: 1433\r\n  username: mylogin@servername\r\n  password: password\r\n  azure: true\r\n  tds_version: 7.3 \r\n\r\nThe environment I have is,\r\nWindows 2012 R2\r\nruby (2.2.3p173)\r\nrails (4.2.5)\r\ntiny_tds (0.7.0)\r\nactiverecord-sqlserver-adapter (4.2.6, 4.2.4)\r\n\r\n\r\nCouple questions,\r\n[1] How do I know TinyTds is using which FreeTds? The one comes with the gem or the one I installed?\r\n[2] I can connect and execute query via FreeTds and TinyTds. The test program also works. How else I can troubleshoot?  \r\n\r\nthank you in advance for the help\r\n"},"comment":{"url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/comments/181070498","html_url":"https://github.com/rails-sqlserver/tiny_tds/issues/249#issuecomment-181070498","issue_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/249","id":181070498,"user":{"login":"metaskills","id":2381,"avatar_url":"https://avatars.githubusercontent.com/u/2381?v=3","gravatar_id":"","url":"https://api.github.com/users/metaskills","html_url":"https://github.com/metaskills","followers_url":"https://api.github.com/users/metaskills/followers","following_url":"https://api.github.com/users/metaskills/following{/other_user}","gists_url":"https://api.github.com/users/metaskills/gists{/gist_id}","starred_url":"https://api.github.com/users/metaskills/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/metaskills/subscriptions","organizations_url":"https://api.github.com/users/metaskills/orgs","repos_url":"https://api.github.com/users/metaskills/repos","events_url":"https://api.github.com/users/metaskills/events{/privacy}","received_events_url":"https://api.github.com/users/metaskills/received_events","type":"User","site_admin":false},"created_at":"2016-02-07T18:15:10Z","updated_at":"2016-02-07T18:15:10Z","body":"OK, I have a handle on this issue now. Please track the progress on the adapter issue here https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/issues/446"}}