MS SQLServer database driver
Yet another and pure python MS SQLServer database driver.
We are testing it on MS SQLServer 2022 on Ubuntu.
But we think it works on older versions.
::
$ pip install minitds
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()