Connect MSSQL(ODBC)

pyodbc_sample1.py

#-*- coding utf-8 -*-
import pyodbc

def test():
  connectString = "DRIVER={SQL SERVER}; SERVER=(local)\SQLEXPRESS;DATABASE=;TrustedConnction=yes;"
  sql = "select sysdb.name from sysdatabases sysdb"
  
  #connect server
  with pyodbc.connect(connectString) as conn:
    cursor = conn.cursor()
    cursor.execute(sql)
    
    for row in cursor.fetchall():
        #Output db name
        print("Name:{0}".format(row))
        
if __name__ =="__main__":
    test()