{"action":"created","issue":{"url":"https://api.github.com/repos/pymssql/pymssql/issues/327","labels_url":"https://api.github.com/repos/pymssql/pymssql/issues/327/labels{/name}","comments_url":"https://api.github.com/repos/pymssql/pymssql/issues/327/comments","events_url":"https://api.github.com/repos/pymssql/pymssql/issues/327/events","html_url":"https://github.com/pymssql/pymssql/issues/327","id":81172841,"number":327,"title":"SQL Azure connectivity issue on Windows","user":{"login":"meet-bhagdev","id":11928821,"avatar_url":"https://avatars.githubusercontent.com/u/11928821?v=3","gravatar_id":"","url":"https://api.github.com/users/meet-bhagdev","html_url":"https://github.com/meet-bhagdev","followers_url":"https://api.github.com/users/meet-bhagdev/followers","following_url":"https://api.github.com/users/meet-bhagdev/following{/other_user}","gists_url":"https://api.github.com/users/meet-bhagdev/gists{/gist_id}","starred_url":"https://api.github.com/users/meet-bhagdev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/meet-bhagdev/subscriptions","organizations_url":"https://api.github.com/users/meet-bhagdev/orgs","repos_url":"https://api.github.com/users/meet-bhagdev/repos","events_url":"https://api.github.com/users/meet-bhagdev/events{/privacy}","received_events_url":"https://api.github.com/users/meet-bhagdev/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2015-05-26T22:52:43Z","updated_at":"2015-05-27T18:42:13Z","closed_at":"2015-05-27T07:55:33Z","body":"I successfully used pymssql to conenct to Azure SQL DB on my ubuntu machine, however if I copy the code over to my windows machine I get the following error message : adaptive server connection failed\r\n\r\nI have FreeTDS installed. Is this an issue or did I not install FreeTDS correctly. I made sure i configured it with openssl and followed all your instructions.\r\n\r\nHere is my code : \r\nmport pymssql\r\nconn = pymssql.connect(server='myserver.database.windows.net', user='myusername@myserver', password='mypassword', database='mydatabase')\r\ncursor = conn.cursor()\r\ncursor.execute(\"INSERT SalesLT.Product (Name, ProductNumber, StandardCost, ListPrice, SellStartDate) OUTPUT INSERTED.ProductID VALUES ('SQL Server Express', 'SQLEXPRESS', 0, 0, CURRENT_TIMESTAMP)\")\r\nrow = cursor.fetchone()\r\nwhile row:\r\n    print \"Inserted Product ID : \" +str(row[0])\r\n    row = cursor.fetchone()\r\n\r\n\r\nThanks,\r\nMeet"},"comment":{"url":"https://api.github.com/repos/pymssql/pymssql/issues/comments/106028246","html_url":"https://github.com/pymssql/pymssql/issues/327#issuecomment-106028246","issue_url":"https://api.github.com/repos/pymssql/pymssql/issues/327","id":106028246,"user":{"login":"ramiro","id":40661,"avatar_url":"https://avatars.githubusercontent.com/u/40661?v=3","gravatar_id":"","url":"https://api.github.com/users/ramiro","html_url":"https://github.com/ramiro","followers_url":"https://api.github.com/users/ramiro/followers","following_url":"https://api.github.com/users/ramiro/following{/other_user}","gists_url":"https://api.github.com/users/ramiro/gists{/gist_id}","starred_url":"https://api.github.com/users/ramiro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ramiro/subscriptions","organizations_url":"https://api.github.com/users/ramiro/orgs","repos_url":"https://api.github.com/users/ramiro/repos","events_url":"https://api.github.com/users/ramiro/events{/privacy}","received_events_url":"https://api.github.com/users/ramiro/received_events","type":"User","site_admin":false},"created_at":"2015-05-27T18:42:13Z","updated_at":"2015-05-27T18:42:13Z","body":"This is great!\n\nThanks Christoph for your help here and for the woenderful service you do\npublishing all these Windows Python packages.\n\nOne question: Do you use OpenSSL or GNU TLS? I'd like to fix this for a\nfuture pymssql release.\nOn May 27, 2015 4:55 AM, \"Meet Bhagdev\" <notifications@github.com> wrote:\n\n> Closed #327 <https://github.com/pymssql/pymssql/issues/327>.\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/pymssql/pymssql/issues/327#event-314600029>.\n>\n"}}