pyodbc.connect() works, but not sqlalchemy.create_engine().connect()
A Pass through exact Pyodbc string works for me:
from sqlalchemy import create_enginefrom sqlalchemy.engine import URLconnection_string = ( r"Driver=ODBC Driver 17 for SQL Server;" r"Server=(local)\SQLEXPRESS;" r"Database=myDb;" r"Trusted_Connection=yes;")connection_url = URL.create( "mssql+pyodbc", query={"odbc_connect": connection_string})engine = create_engine(connection_url)cnxn = engine.connect()rows = cnxn.execute("SELECT name FROM sys.tables").fetchall()print(rows)