{"action":"created","issue":{"url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/218","labels_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/218/labels{/name}","comments_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/218/comments","events_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/218/events","html_url":"https://github.com/rails-sqlserver/tiny_tds/issues/218","id":101415113,"number":218,"title":"TinyTds::Error: Unable to connect: Adaptive Server is unavailable or does not exist","user":{"login":"dharmdip","id":21830,"avatar_url":"https://avatars.githubusercontent.com/u/21830?v=3","gravatar_id":"","url":"https://api.github.com/users/dharmdip","html_url":"https://github.com/dharmdip","followers_url":"https://api.github.com/users/dharmdip/followers","following_url":"https://api.github.com/users/dharmdip/following{/other_user}","gists_url":"https://api.github.com/users/dharmdip/gists{/gist_id}","starred_url":"https://api.github.com/users/dharmdip/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dharmdip/subscriptions","organizations_url":"https://api.github.com/users/dharmdip/orgs","repos_url":"https://api.github.com/users/dharmdip/repos","events_url":"https://api.github.com/users/dharmdip/events{/privacy}","received_events_url":"https://api.github.com/users/dharmdip/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/milestones/3","html_url":"https://github.com/rails-sqlserver/tiny_tds/milestones/1.0.0","labels_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/milestones/3/labels","id":1348878,"number":3,"title":"1.0.0","description":"Now that 0.7.0 has working Windows builds again, we want to take this to the next level and allow static builds for everyone while also making all FreeTDS bins available within TinyTDS.","creator":{"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},"open_issues":9,"closed_issues":9,"state":"open","created_at":"2015-10-10T22:15:46Z","updated_at":"2015-11-16T02:50:27Z","due_on":"2015-11-30T05:00:00Z","closed_at":null},"comments":23,"created_at":"2015-08-17T12:57:54Z","updated_at":"2015-11-16T12:37:46Z","closed_at":null,"body":"i am trying with FreeTds. I am checking on Windows server 2012 R2. I keep getting error Adaptive Server is unavailable or does not exist (TinyTds::Error), i went through firewall but it seems fine also i am able to connect from SQL management studio.\r\n\r\nAlso later i tried with different ruby version and dev-kit but end-up with same error.\r\n\r\nTinyTds::Error: Unable to connect: Adaptive Server is unavailable or does not exist\r\n\r\nAny thought?"},"comment":{"url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/comments/157015250","html_url":"https://github.com/rails-sqlserver/tiny_tds/issues/218#issuecomment-157015250","issue_url":"https://api.github.com/repos/rails-sqlserver/tiny_tds/issues/218","id":157015250,"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":"2015-11-16T12:37:46Z","updated_at":"2015-11-16T12:37:46Z","body":"OK... so I think I see what is going on here and you may be the best to debug your situation. From what I can tell, you have installed your own FreeTDS and you are not using the Windows gems' precompiled static FreeTDS. Does this make sense? Because you have this complex setup going on... there could be NUMEROUS places that a small config could cross the steams between the static lib and the one you have installed. For example, maybe you have TDSVER or FREETDS or some other ENV set that makes your static lib use a non local conf file? I honestly have no idea. But you are honestly going to be better to debug your setup.... I can only offer hints from a distance. For example, if you have the tools to build your own gem and install things, have you tried using the master branch of this repo?"}}