Timeout not being enforced in SQL query about pyodbc HOT 7 CLOSED

import pyodbc

cnxn = pyodbc.connect("DSN=msodbcsql18_199;UID=scott;PWD=tiger^5HHH")
cnxn.timeout = 33
crsr = cnxn.cursor()
print(crsr.execute("SELECT 1 AS foo").fetchval())

import pyodbc

cnxn = pyodbc.connect("DSN=msodbcsql18_199;UID=scott;PWD=tiger^5HHH")
cnxn.timeout = 5
crsr = cnxn.cursor()
print(crsr.execute("""\
SET NOCOUNT ON;
WAITFOR DELAY '00:00:10'
SELECT 1 AS foo;
""").fetchval())

import pandas as pd
import pyodbc


class DbClass():
    def _connect(self):
        self.connection_string = "DSN=msodbcsql18_199;UID=scott;PWD=tiger^5HHH"
        return pyodbc.connect(self.connection_string)

    def launch_query(self, query, params=None, timeout=10):
        try:
            with self._connect() as conn:
                conn.timeout = timeout
                cursor = conn.cursor()
                cursor.execute(query, params or ())
                if cursor.description:
                    columns = [column[0] for column in cursor.description]
                    rows = cursor.fetchall()
                    data = [list(row) for row in rows]
                    return pd.DataFrame(data, columns=columns)
                else:
                    return None
        except pyodbc.Error as e:
            print("An error occurred:", e)
            if 'HYT00' in str(e):  # Timeout error code
                print("Query execution was cancelled due to timeout.")
            # Handle or re-raise exception
            return None


sql = """\
SET NOCOUNT ON;
WAITFOR DELAY '00:00:10';
SELECT 1 AS foo;
"""
db = DbClass()
result = db.launch_query(sql, timeout=5)
"""console output:
$ python main.py 
An error occurred: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Query timeout expired (0) (SQLExecDirectW)')
Query execution was cancelled due to timeout.
None
"""