Skip to content

Latest commit

 

History

History
25 lines (17 loc) · 793 Bytes

install_odbc.md

File metadata and controls

25 lines (17 loc) · 793 Bytes

How to use pyodbc to access SQL Server

  1. Install Driver from Microsoft (Based on what system do you operate)
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list

apt-get update

ACCEPT_EULA=Y apt-get install msodbcsql17
ACCEPT_EULA=Y apt-get install mssql-tools

apt-get install unixodbc-dev


echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

2 Install ODBC Python Library

pip install pyodbc