minitds
Yet another Python MS SQLServer database driver.
Support platform
- Python 3.5+
Support database
We test with MS SQLServer 2019 on Ubuntu. But we think it works with the following versions.
- MS SQLServer 2012, 2014, 2016, 2017, 2019
- Microsoft Azure SQL Database
Installation
$ pip install minitds
Example
Query:
import minitds conn = minitds.connect(host='localhost', user='sa', password='secret', database='database_name') cur = conn.cursor() cur.execute('select foo, bar from baz') for r in cur.fetchall(): print(r[0], r[1]) conn.close()
Execute Procedure:
import minitds conn = minitds.connect(host='localhost', user='sa', password='secret', database='database_name') cur = conn.cursor() cur.callproc('something_proc', [123, 'ABC']) conn.close()
Restrictions
- Support connecting through SQL Server Authentication only.