Hi, I'm trying to set up a Python (flask) App Service that accesses an Azure SQL Server. In order to access the server, the app service needs the ODBC drivers installed.
Error from SQLAlchemy:
2020-05-07T23:23:47.256046274Z sqlalchemy.exc.DBAPIError: (pyodbc.Error) ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found (0) (SQLDriverConnect)")
2020-05-07T23:23:47.256050074Z (Background on this error at: http://sqlalche.me/e/dbapi)
I have tried using 'ODBC 13 for SQL Server' as the driver, along with trying to install unixODBC using a prebuild script, but neither helped.