Skip to content

Instantly share code, notes, and snippets.

@deterralba
deterralba / pyodbc.py
Created September 10, 2018 12:51
pyodbc / sqlalchmey / sqlserver
"""
I had some difficulties to connect to a local SQL Server 17 test database using sqlalchemy.
I made it work using these resources:
- setup the sql server db: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-2017
- setup the python drivers (it's so painful...): https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017
- SqlAlchemy documentation: http://docs.sqlalchemy.org/en/latest/dialects/mssql.html#connecting-to-pyodbc
Here are some of the errors that I encountered: