I would like to develop an apps using python/webapp2, which is required SQL Azure database hosted in Azure Cloud. How can i connect python to SQL Azure?
Asked
Active
Viewed 4,952 times
3
-
Have you checked [Windows Azure: Python Developer Center](http://www.windowsazure.com/en-us/develop/python/)? – Pedro Romano Nov 05 '12 at 09:55
-
Yes, i did. Can't find any tutorial there. They do have tutorial for MySQL, but SQL Azure. – Danny Hong Nov 05 '12 at 09:58
-
1[Python App using storage](http://www.windowsazure.com/en-us/develop/python/tutorials/web-app-with-blob-storage/)? – Pedro Romano Nov 05 '12 at 10:40
1 Answers
5
Try pyodbc with FreeTDS and format your connection string as explained in this answer:
TDSVER=8.0 tsql -H XXXXXXXX.database.windows.net -U Username -D DatabaseName -p 1433 -P Password
Also make sure that you configure SQL Azure correctly in order to allow your IP to access the database.
Community
- 1
- 1
Sandrino Di Mattia
- 24,739
- 2
- 60
- 65