stefan-wegener/python-mssql.md

Created August 2, 2018 06:43

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/stefan-wegener/4360f07fe8f258592f2d065e29308d0b.js"></script>
Save stefan-wegener/4360f07fe8f258592f2d065e29308d0b to your computer and use it in GitHub Desktop.

Download ZIP

Python: Connect with MSSQL DB

Raw

python-mssql.md

Install appropriate ODBC driver

curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
sudo yum remove unixODBC-utf16 unixODBC-utf16-devel #to avoid conflicts
sudo ACCEPT_EULA=Y yum install msodbcsql17

(Source)[https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017]

Make sure dependencies for pyodbc package are met

On RHEL7:

gcc
gcc-c++
python-devel
unixODBC-devel

Install pyodbc package

pip install pyodbc

How to connect in Python

import pyodbc

db = pyodbc.connect(
        r'DRIVER={ODBC Driver 17 for SQL Server};'
        r'SERVER=<URL_to_DB>;'
        r'DATABASE=<DB_name>;'
        r'UID=<username@URL_to_DB>;'
        r'PWD=<password>'
    )

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment