Answers for "connect to azure sql database from python"

connect to azure sql database from python

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:
    	# code...
        # ex: cursor.execute("SELECT TOP 3 name, collation_name FROM sys.databases")