CODEWITHSUNDEEP
pythonazure
Danny Hong
Danny Hong

Reputation: 1482

How to connect python to SQL Azure?

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?

Upvotes: 3

Views: 5038

Answers (1)

Sandrino Di Mattia
Sandrino Di Mattia

Reputation: 24895

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.

Upvotes: 5

Related Questions