python(10) : python SQLAlchemy sqlserver(pyodbc.Error) (‘01000‘, “[01000] [unixODBC][Driver Manager]

sqlalchemy.exc.DBAPIError: (pyodbc.Error) ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found (0) (SQLDriverConnect)")

centos python SQLAlchemy 连接sqlserver报错

系统: CentOS Linux release 8.5.2111

解决:

yum remove unixODBC

curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
ACCEPT_EULA=Y yum install msodbcsql17

连接参数

app.config['SQLALCHEMY_DATABASE_URI'] = 'mssql+pyodbc://username:password@your_server_name/your_database_name?driver=ODBC+Driver+17+for+SQL+Server'
db = SQLAlchemy(app)

Windows环境连接参数

app.config['SQLALCHEMY_DATABASE_URI'] = 'mssql+pyodbc://username:password@your_server_name/your_database_name?driver=SQL+Server'
db = SQLAlchemy(app)