db_connect.py

# Works on windows, but a differentent set of drivers are needed for linux "FreeTDSs"
# Change file odbcinst.ini by adding
# [FreeTDS]
# Description=v0.63 with protocol v8.0
# Driver=/usr/lib/i386-linux-gnu/odbc/libtdsodbc.so
# UsageCount=2 
# In code change "ODBC Driver 17 for SQL Server" for "DRIVER=FreeTDS"
import pyodbc 

server = 'MYIP' 
database = 'MYDB' 
username = 'MYUSERNAME' 
password = 'MYPASSWORD' 
cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
cursor = cnxn.cursor()

#Sample test
cursor.execute("SELECT @@version;") 
row = cursor.fetchone() 
while row: 
    print(row[0])
    row = cursor.fetchone()