我尝试使用python将我的Synapse SQL数据库与Active Directory身份验证连接，使用以下代码：

import pyodbc
server = '<servername>'
db_name = '<dbname>'
conn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER={'+server+'};Authentication=ActiveDirectoryIntegrated;DATABASE={'+db_name+'};')
conn.timeout = 3000
return conn

我得到以下错误：

通过这个帮助，我安装了ODBC 13的SQL驱动程序，并使用下面的代码检查：

import sqlalchemy as sa
   
username = "username"
password = "password"
host = "<servername>"
database = "<dbname>"
authentication = "ActiveDirectoryPassword"
conn_string = sa.engine.url.URL.create(
     "mssql+pyodbc",
     username=username,
     password=password,
     host=host,
     port=1433,
     database=database,
     query={"driver": "ODBC Driver 13 for SQL Server","authentication": authentication},
 )
engine = sa.create_engine(conn_string, pool_timeout=30)
connection = engine.connect()

连接成功，未出现任何错误。