Python "使用odbc_connect(raw)连接字符串登录失败；可用于pyodbc"

下面的pyodbc连接工作正常:

import pyodbc
import pandas as pd
conn = pyodbc.connect(Driver='SQL Server',
                      Server='some_server_address,1433',
                      Database='some_db',
                      UID ='some_user',
                      PWD = 'some_password')

cursor = conn.cursor()
df = pd.read_sql_query('''select top 100 * from tableA''', conn)
cursor.close()
conn.close()

当我try 与SQLAchlory相同时，它失败了

from sqlalchemy.engine import URL
from sqlalchemy import create_engine
import sqlalchemy as sa
    
connection_string = "DRIVER={SQL Server};SERVER=some_server_address,1433;DATABASE=some_db;UID=some_user;PWD=some_password"
connection_url = URL.create("mssql+pyodbc", query={"odbc_connect": connection_string})
engine = create_engine(connection_url)
conn = engine.connect()

错误如下:

InterfaceError: (pyodbc.InterfaceError) ('28000', "[28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'some_user'. (18456) (SQLDriverConnect); [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'some_user'. (18456)")
(Background on this error at: https://sqlalche.me/e/20/rvf5)

我该怎么办？

Update 正如下面所建议的，我try 了

import pyodbc
import pandas as pd
connection_string = "DRIVER={SQL Server};SERVER=some_server_address,1433;DATABASE=some_db;UID=some_user;PWD=some_password"
conn = pyodbc.connect(connection_string)
    
cursor = conn.cursor()
df = pd.read_sql_query('''select top 100 * from tableA''', conn)
cursor.close()
conn.close()

一切工作完美