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)