DB-API interface to Microsoft SQL Server for Python. (new Cython-based version)
Project description
pymssql - DB-API interface to Microsoft SQL Server
A simple database interface for Python that builds on top of FreeTDS to provide a Python DB-API (PEP-249) interface to Microsoft SQL Server.
Detailed information on pymssql is available on the website:
New development is happening on GitHub at:
There is a Google Group for discussion at:
Getting started
pymssql wheels are available from PyPi. To install it run:
pip install -U pip
pip install pymssql
Most of the times this should be all what’s needed. The official pymssql wheels bundle a static copy of FreeTDS and have SSL support so they can be used to connect to Azure.
Basic example
conn = pymssql.connect(server, user, password, "tempdb")
cursor = conn.cursor(as_dict=True)
cursor.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')
for row in cursor:
print("ID=%d, Name=%s" % (row['id'], row['name']))
conn.close()
Recent Changes
Version 2.2.3 - 2021-12-21 - Mikhail Terekhov
General
Build wheels for Python-3.10.
Use FreeTDS-1.3.4 for official wheels on PyPi.
Enable krb5 in Linux wheels (#734).
Fix UnicodeEncodeError for non-ascii database name (#484).
Fix pymssql.Binary (#504).
On macOS check for FreeTDS in homebrew prefix when building.
Some documentation changes.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
Hashes for pymssql-2.2.3-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 75e65e53f5014f24dae8c150f532e9313ce0c166123b0951a334d61ada0aaece |
|
MD5 | a83f5fe16077af173422d42137742c21 |
|
BLAKE2b-256 | 6ae5335f6439bfeac137191ec7bcf2ee44dfa08df22244d65255b7b56f023607 |
Hashes for pymssql-2.2.3-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2bffb7d07a3914b73086a17583f0a0ca68dfc93f7c70b3e214beeacbd2339e12 |
|
MD5 | d96f8719092237933486df0a78bb92a4 |
|
BLAKE2b-256 | ad7a011f79927d6a7d354629340f94aef00ac63af31c8fc2237d17f39174a785 |
Hashes for pymssql-2.2.3-cp310-cp310-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 852fe689b4630aa453eb02b091240d98e07eb60fd7a3c150396d0eb7fa10780a |
|
MD5 | 9c056c09b91c819428b4cab6dc6a3f72 |
|
BLAKE2b-256 | ae5b33637d249c33e837b065841f1aa1b1005d26f24fef65c6da8eff80e88bec |
Hashes for pymssql-2.2.3-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 496ad5ee139f6d15c5006f614e602891f89740205e58b3aee67d9a22e6bc941c |
|
MD5 | 49ef663e39c2fb5abe1e74e55c2dcce9 |
|
BLAKE2b-256 | 639e9b451a9b872019e468de0be4620418e6cc34aeb3808cf0a40c9cc14f35ab |
Hashes for pymssql-2.2.3-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ddd9c6ddf8966292d3a4f1eff27757d91d7f572f8b8c34ec3aa0eebb1c1f5da2 |
|
MD5 | 6828a6468362f8052db1ca16a5163f24 |
|
BLAKE2b-256 | f995d550c2197c60f64d0c70902e6f6def8c3b882c031fc6e0180219da5643e5 |
Hashes for pymssql-2.2.3-cp39-cp39-manylinux_2_24_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d4f6ae1888fc41e2fabfad16806699c0b0ffdc1ac22c2962f5918c69b5d58ca6 |
|
MD5 | f2bb2e7152774de0a97ac3a52fc53e35 |
|
BLAKE2b-256 | 92ae186f5cc66e0b1d8afb829adee4e0ed5070d7d0b6ed08152c59dedb7f8d68 |
Hashes for pymssql-2.2.3-cp39-cp39-manylinux_2_24_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f53203f91baa569606c1731d2ac4fb5d79cbce28fa7d902a2938c31a96b984e5 |
|
MD5 | 525805bf59d6e8db3da429b5e0a4ab72 |
|
BLAKE2b-256 | 32533c3fa1c872aeaf5d30051d050124285ff4bb9d4da132ddfcac2c673838d4 |
Hashes for pymssql-2.2.3-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1ded7fca8bf196b86c1cccb833960b48d946b437849a08a8a25c476ab1b335fb |
|
MD5 | be3b39049efba7e7d6050b79228261c1 |
|
BLAKE2b-256 | 483a0637a0c4f3559a08e9148104757dabc841ba80ed7b4c44b4a338ada8bc4d |
Hashes for pymssql-2.2.3-cp39-cp39-manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | deab7a7e9dfaf11f04234d60faa821244fb820db104dc5c47aedf8c4751d9c6b |
|
MD5 | cfc20650b4e2dc4537d7e792497b0786 |
|
BLAKE2b-256 | d6699f645101efd8eef6ba408b491e13bfe73e9946b1c11328320ad0c96c0b9c |
Hashes for pymssql-2.2.3-cp39-cp39-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4cc13762966ddd1e06d324662bee967fdbc8924872cde4a891556f0401ef9de0 |
|
MD5 | a3c4888d810e1c19df10555254f9026d |
|
BLAKE2b-256 | 953dbf3afe68af9ae8a820e2e302077f1c22f32890917a282753378437aa176e |
Hashes for pymssql-2.2.3-cp39-cp39-manylinux_2_12_i686.manylinux2010_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b21db3e4e946b947076b915cc2a91e5c052ff1c81409fb33f1d954554600e866 |
|
MD5 | 5b1152022dae9fc59baf8f9932e9b7a0 |
|
BLAKE2b-256 | 0ab87d69c0d4255ebd13b05d44e543527dc2d1b090b5fe838a9704d26a1579cb |
Hashes for pymssql-2.2.3-cp39-cp39-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d9cc4ef9ce01f14ab435e72914719a0f37999bae60b82d50bd1f0ce865083011 |
|
MD5 | 5ae406423293f697495405bd3b912b31 |
|
BLAKE2b-256 | a10ddbd7317ad3a80cf129718594fc20f356d3ef68f136ec29840608c0e5ae91 |
Hashes for pymssql-2.2.3-cp39-cp39-manylinux_2_5_i686.manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8ab926fc78108e9e76e844794b5de5fca20ed2f0326d788ecc529072ce9bd6c0 |
|
MD5 | 049f7596441973b5aa331c280fe5fbe9 |
|
BLAKE2b-256 | cd9d534a36c12dcde7266273f46054c526ea38c8aa939f99c50b19f29b9b33b6 |
Hashes for pymssql-2.2.3-cp39-cp39-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8a526ae0ce3f3c9acdfc4db1e61cf82bac528ee2848496c7d7eb25881e4824af |
|
MD5 | a008f86f280b022cb31de9c617007802 |
|
BLAKE2b-256 | 660acd881e3c6a8a9784d67435f459e35498606512e72d7056ca1c8525db6499 |
Hashes for pymssql-2.2.3-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | aab0a93cab37273228b859cf674449b0781df605a26739b72e5bb029682bd618 |
|
MD5 | f50d2c7fdcb6358cad997d70b0238c4a |
|
BLAKE2b-256 | 840a4eb1b598519e667a23ecf406b56eaebf53ed40d955b68638ed232e0f70ea |
Hashes for pymssql-2.2.3-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | df3c039679df3ce1ad3e55a8daccfd5afd65d2e2aed738515ecad6ad778fb160 |
|
MD5 | 2750bc4a70c9cad2a5bc9a551d38e562 |
|
BLAKE2b-256 | 7b5173ebe0194c18a633c6757a4c74055a9194bf0a586117b0388225b32ee760 |
Hashes for pymssql-2.2.3-cp38-cp38-manylinux_2_24_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fc103b304a9bf2a6f92f2dee12b6a9212000781c17a9aa280621cd09f0f5eda0 |
|
MD5 | d73717e2c2b05c072937dac906ebdf81 |
|
BLAKE2b-256 | edea30b672c1bae55cdfbee4975690da746656a834139314d437bcbb9bd0eb3c |
Hashes for pymssql-2.2.3-cp38-cp38-manylinux_2_24_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6ee59e594c10bd7dab7776ff6278f318625b79d7c8e9ef9813af6bd953d7d748 |
|
MD5 | d25a9585177b3c2307b45a0d33ca087d |
|
BLAKE2b-256 | 8654e4524908e4f165bbeceb24671754eecf35611e36a724319f38ae1481652a |
Hashes for pymssql-2.2.3-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | de6aa047efe4ba438261477ebcb11bba6d913bbaae114d55d95f04760c3be6df |
|
MD5 | 632240e68cd9a4bcaa0437895143bf92 |
|
BLAKE2b-256 | 78c137ea72359ffced75227213fe6ec45c00e9f34d7a6f266b13de8f265412b9 |
Hashes for pymssql-2.2.3-cp38-cp38-manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7d995b0e20961e4366ecbef34faf2ef8a05a963780fb5f7ca35c07c61369c889 |
|
MD5 | bd56d80ff8a3759f457c2b267603a27b |
|
BLAKE2b-256 | 573813316cf237877e1783b9e48c4f45ea38220a11293802347d26e06fd65673 |
Hashes for pymssql-2.2.3-cp38-cp38-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ec76e9773d7af22f39cc902e92946f453efec1af3037e8b95dcdf568d3bdbee2 |
|
MD5 | 84891faf5982dcc06c5e4a293643d56b |
|
BLAKE2b-256 | cb9cf66478fecc660426d62aef87b1108c4287f4e2ff6019fcefe67b3a76e727 |
Hashes for pymssql-2.2.3-cp38-cp38-manylinux_2_12_i686.manylinux2010_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6a09fb8456279acd87615708a60bc299640e0be149a117508eba6f1c4ad0fb3e |
|
MD5 | 2327fc037c0a1bfc93c3752beef49f0d |
|
BLAKE2b-256 | 9de55cc585abf8dd6b301e8a041cbdc310e81d36336c807320b3fcd7dffe71af |
Hashes for pymssql-2.2.3-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 46a8ad501353de0539b35d4a8b6a0f27430e9e240377673b42e9aceedb5313e4 |
|
MD5 | 69450d39357576e63ce56690d047717b |
|
BLAKE2b-256 | 6d202b9225f303f5ab38ed1d9e3e63352e44c403af1392b5aef9d033148c9353 |
Hashes for pymssql-2.2.3-cp38-cp38-manylinux_2_5_i686.manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e83e049b1d7a64d5aab9fc31477ebeb7ae4a0dcd40f273ee5cfd22b3ed87004d |
|
MD5 | 6d85f9304faeb57a82997759cfd8fdad |
|
BLAKE2b-256 | 9c9edd4319cd1d52a964682697abbf1cfcd03ce4a052b03c76c7abce657cd6c7 |
Hashes for pymssql-2.2.3-cp38-cp38-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8f81d90d711a151a72960e3ad1dd8cb71b9d288979e1ead913e1e654e7ee504d |
|
MD5 | 87335ba6cea74d620e551a2f32543056 |
|
BLAKE2b-256 | 2cebddc7eb2e2f4bc96ae282761dcc19f5c65588d3da9919f79c9fec9afd9f82 |
Hashes for pymssql-2.2.3-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7d3ccb1fe4fa957ad0d430c0efa342c3ead9fd3d546cc867042b146620d524ee |
|
MD5 | 99f6db7079f9820088069e6edfd32ef1 |
|
BLAKE2b-256 | 396e2f99dcf69b139849a0b09e3134b0057d8eb0249dbdb9b4473a1277013694 |
Hashes for pymssql-2.2.3-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bd6b49ad64026eac1b23c2ab8d237b81d0eb83fc3872562b9101cc970581735d |
|
MD5 | 9801976eefb31ef600726bdf9c07bf32 |
|
BLAKE2b-256 | 00cf9ba218c0d661e8960e6ddca76c21d20d42b1184a24b16324be9eb633bfb7 |
Hashes for pymssql-2.2.3-cp37-cp37m-manylinux_2_24_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6bfd0859201095b4a8913e88ec9999c72053e2f92aa05413b32ac5855970b726 |
|
MD5 | 01883ef14b51df560754fec4d83c31fc |
|
BLAKE2b-256 | 98a8e70ad68ba55fa980dfa967666656012dbbdb99b879bb28e6fcf0fa7e7853 |
Hashes for pymssql-2.2.3-cp37-cp37m-manylinux_2_24_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2c08ed13f090b9df251ba2590a1316939dea1744679ec3f164968e4b51263b53 |
|
MD5 | ee455033e2287c13d5b972d6e99bff93 |
|
BLAKE2b-256 | 9e69e2405586d6c8185e910832f76449103c6a2a3e114ced1e6f0d82ebf976fb |
Hashes for pymssql-2.2.3-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3b13bc9d7c82ef24fd2df690747e99160bd6611d97b875518757836ab3c3fea0 |
|
MD5 | d1293ed72b86ff8e99c539d1ea8920be |
|
BLAKE2b-256 | d5e0e07c546f8f24054bbed2bf051a07f95452b16c6355a8d04b5b99668c5139 |
Hashes for pymssql-2.2.3-cp37-cp37m-manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9d06c950d13c198a6a70f846298d3f4ba820b998341b61c487049c3e5dd19223 |
|
MD5 | e7b89f31576828cf9523282ff3cd7dab |
|
BLAKE2b-256 | ed4ab1d23b7431fa7d3ce18462e4de1fda1343c762e3cce46ee50b5c6ad93e1b |
Hashes for pymssql-2.2.3-cp37-cp37m-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8eaba0e0fe013dd727f960e7d025071d3b03123eb41b9fc11f225728e00cc2b4 |
|
MD5 | 80455c1c1623e1d20278110502980b3f |
|
BLAKE2b-256 | 8a6a1efd7fe8bd0f3dbcaa30fc4fe8c0b0cf06291eaec75d2ac03abe61c643a1 |
Hashes for pymssql-2.2.3-cp37-cp37m-manylinux_2_12_i686.manylinux2010_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5cc68a295207ced45c0155e263ecdd249cbcfac2d77a58d2dbda5c54a532044f |
|
MD5 | 7038f74ca8623d6c04d12028fb435517 |
|
BLAKE2b-256 | 43a4ee1702bb8699373a5cb73f300fecfcbbc4e0edaaad3453870cff985fdae7 |
Hashes for pymssql-2.2.3-cp37-cp37m-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7b7d04c3abf78961d04c5c620118e5b34589619cd9f7a95a4dbc439186095bc4 |
|
MD5 | fca4851d0092a1cb0debd9b659415761 |
|
BLAKE2b-256 | 978e7aaa97d88bae7aa7a0e66155a371c9a397a5dad8e573760bc1593ba24ac7 |
Hashes for pymssql-2.2.3-cp37-cp37m-manylinux_2_5_i686.manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 860979466f9dd6d7d20fb83db2498aa67bab172a85e660a93a93c9d716b8e268 |
|
MD5 | 6f2d224d7eb85643aeff70a8d2fed367 |
|
BLAKE2b-256 | 5f6355c61af2c93bfcb392cd0a3bdfd72a34f06138728470cd5347355d6d30d1 |
Hashes for pymssql-2.2.3-cp37-cp37m-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0a1ccec4eb9bb35ad9f211428793fd29e59f3902279ad2903133d6c2081550c1 |
|
MD5 | 4b2438787cfba16ffeebd54d2b061ed0 |
|
BLAKE2b-256 | a3a63346fb4e5688af9b8d1325a8c249b324c72b642dc6bd1637cf0d078576bb |
Hashes for pymssql-2.2.3-cp36-cp36m-manylinux_2_24_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 538b5a4ca9b4bd3f0719acb608e08e1d586a08ed9ed0d7ea1ffa3ef03518df68 |
|
MD5 | f4be39efdc6fe63038b167bc76214656 |
|
BLAKE2b-256 | 24ac11199b605f5e0edf9086da5ea9b8fe16ef7f3e51c7b883fa375f2fc16baa |
Hashes for pymssql-2.2.3-cp36-cp36m-manylinux_2_24_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d402ed357f5da445a29a6a844ac4359872d3870e6ee034ec049e83095d6cd00e |
|
MD5 | 8a05cfb0a6be5b2e56952a2f1b567a1f |
|
BLAKE2b-256 | e4a0878870e1f6de897cb857183fef55448848ea5a78a51bf7ef7ca3bb6a9135 |
Hashes for pymssql-2.2.3-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6cb52bf5d0eabf510b1ebc8b38e71cd3ca877e69e0e424f15e1f7b319e49b10e |
|
MD5 | ae39a725ba46de9ffd40fa78fc400178 |
|
BLAKE2b-256 | 59559a864839a101106359ed19f2bd21aacbf5fc40aea70c35e80cdf5f7df1bb |
Hashes for pymssql-2.2.3-cp36-cp36m-manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 873d026423768f4e1ec0b452ff9fe951beb4632e3f314c19b22a30586db1de02 |
|
MD5 | b341027f85317dd7076bed6be982defb |
|
BLAKE2b-256 | c32ee5ce73ec799eb993b83382d0268d3b809ee3cb4ade27f2cc0a089e35d09c |
Hashes for pymssql-2.2.3-cp36-cp36m-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 52a8163fcbdb1ebe2756d5a9f439ea8f30b9748855e782c1f98465050e8bab61 |
|
MD5 | 5ccc839d7b9cd4fb4bb146bfee3fa049 |
|
BLAKE2b-256 | 9ab1181d060d37fa0fc486da7439030da0a0a887550d0c6fcba9a72056c7cf7e |
Hashes for pymssql-2.2.3-cp36-cp36m-manylinux_2_12_i686.manylinux2010_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d90eb4dd06f1b8eb4805d137e8a0747665ec15c46736a4f1cc01afe6da4d07b7 |
|
MD5 | 6c7f62a4b4095e0e57512d95ea31c206 |
|
BLAKE2b-256 | c3db70eede5f654da5e273a3d0813d225a2c4479ff1370406c7e5ceaab41253a |
Hashes for pymssql-2.2.3-cp36-cp36m-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3f7def19af5af2d83f2f7559b67ae37315d76807e4e6d7957d53755f982d1d8b |
|
MD5 | 7080648221bd79000f927e752e828f65 |
|
BLAKE2b-256 | 62f9652e65c680742d0405f7789218dc5ade19663cb87f29ac349f33bd512b16 |
Hashes for pymssql-2.2.3-cp36-cp36m-manylinux_2_5_i686.manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0bc2e51739d932fc7af44354c00297baa451f99a3e3d7a59a6aa3be5b2534076 |
|
MD5 | 070c260be46a739b27cd56336e08ac7b |
|
BLAKE2b-256 | 53e0e50f1f226efe48d3659b585541dd452baded0646d280d3ba08f3b24800dc |