pytds

Python DBAPI driver for MSSQL using pure Python TDS (Tabular Data Stream) protocol implementation

It can be used with https://bitbucket.org/denisenkom/django-pytds as a django database backend.

Features

• Fully supports new MSSQL 2008 date types: datetime2, date, time, datetimeoffset
• MARS

Install

To install run this command:

pip install python-tds

For a better performance install bitarray package too:

pip install bitarray

To connect to database do

import pytds
conn = pytds.connect('server', 'database', 'user', 'password')