我无法使用Python从Unix连接到SQL服务器。
由于其他依赖项,我将无法像在Pyodbc: Login Timeout Error中所解释的那样,将驱动程序从ODBC Driver 17 for SQL Server替换为ODBC Driver 13 for SQL Server。
请问有没有其他替代方案?
代码:
import sqlalchemy as sa
from urllib import parse as db_parse
from sqlalchemy import event
params = db_parse.quote_plus(r"DRIVER={ODBC Driver 17 for SQL Server};SERVER='server,port';DATABASE=DB_NAME;username=USER_ID;password=PWD;Trusted_Connection=yes")
engine = sa.create_engine('mssql+pyodbc:///?odbc_connect={}'.format(params))
connection = engine.connect()
错误:
sqlalchemy.exc.OperationalError: (pyodbc.OperationalError) ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)') (Background on this error at: http://sqlalche.me/e/e3q8)
SERVER='server,port'
是错误的,服务器名称和端口不需要加引号。 - Panagiotis Kanavos