Python retrieve data from SQL Azure

This blog article shows you how to connect Python to SQL Azure. This blog article expects the following:

The code looks quite short. In fact, that is all you need to get back some data from SQL Azure.

In the blog article Python retrieve data from SQL Server, https://chanmingman.wordpress.com/2020/11/22/python-retrieve-data-from-sql-server/, you can connect to SQL Server on-premise. With the minor changes you can connect the Python code to SQL Azure.

The driver in the connection for the SQL Server on-premise is.

Driver={SQL Server}

You need to change the driver to.

driver= ‘{ODBC Driver 17 for SQL Server}

The complete code snippet as follow.

import pyodbc

server = ‘server.database.windows.net;’

database = ‘database;’

username = ‘username;’

password = ‘Password;’

driver= ‘{ODBC Driver 17 for SQL Server}’

with pyodbc.connect(‘DRIVER=’+driver+‘;SERVER=’+server+‘;PORT=1433;DATABASE=’

+database+‘;UID=’+username+‘;PWD=’+ password) as conn:

with conn.cursor() as cursor:

cursor.execute(“SELECT TOP 20 * FROM Products”)

row = cursor.fetchone()

while row:

print (str(row[0]) + ” “ + str(row[1]))

row = cursor.fetchone()

About chanmingman