python-script-with-pyodbc.py

import pyodbc
import struct

def use_token(server_name, access_token):
    connection_string = 'Driver={ODBC Driver 17 for SQL Server};server='+server_name+';database=master;'
    SQL_COPT_SS_ACCESS_TOKEN = 1256
    
    exptoken = b''
    for i in bytes(access_token, "UTF-8"):
        exptoken += bytes({i})
        exptoken += bytes(1)
    tokenstruct = struct.pack("=i", len(exptoken)) + exptoken
    cnxn = pyodbc.connect(connection_string, attrs_before = { SQL_COPT_SS_ACCESS_TOKEN:tokenstruct })
    cursor = cnxn.cursor()

    return cursor, cnxn