More than 5 years have passed since last update.

pymssqlをインストール

SQLServer
Python3

Posted at 2018-11-22

pymssqlのインストールがめんどくさかったのでメモ

step1 pymsssqlのインストール


> sudo apt-get --assume-yes update  
> sudo apt-get --assume-yes install freetds-dev freetds-bin  
> sudo apt-get --assume-yes install python-dev python-pip  
> sudo pip install pymssql

step2 sqlserverに接続

import pymssql  
conn = pymssql.connect(server='yourserver.database.windows.net', user='yourusername@yourserver', password='yourpassword', database='AdventureWorks')

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up