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.2 - 2021-07-24 - Mikhail Terekhov
General
Use FreeTDS-1.3 for official wheels on PyPi.
On macOS use delocate to bundle dependencies when building wheels.
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.2-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 213fc0f970324ed5eac25d9442e5b516724f65ed1a96ed6c0a474dd7419b6a97 |
|
MD5 | 96d191625055fb3e5a0664ee9b42880b |
|
BLAKE2b-256 | 8c5b9e9c1624aa687f978461469ff24564d901ca3a7d541f77e3176edd802af5 |
Hashes for pymssql-2.2.2-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 00b5d8d0e6e99dd07677f663a42fe3b53285db02682f9ea8271dab0e30e4404f |
|
MD5 | 809bdc6526e2b5251e1ffb78fec2fc00 |
|
BLAKE2b-256 | 7a2b9036f7127af8f4333df985016611411c670bc914f825bcab8f2c3d0b0c51 |
Hashes for pymssql-2.2.2-cp39-cp39-manylinux_2_24_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0932ed12474cb926a33ba5b623506d29cf1c170e2ea7ca75f342bb5fe3a67906 |
|
MD5 | b0b9f10b7d455b02db00d4dceacf16ee |
|
BLAKE2b-256 | 7810de0e49f1906f73f23dab12b49d97085edbe3733b87d49f273d8a868c6bca |
Hashes for pymssql-2.2.2-cp39-cp39-manylinux_2_24_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9755267acc83568adc4e89cc5668424d34ef651d0a2e827304e7f995b5dcbca8 |
|
MD5 | b1c1759063ed5baf12676dcbdfef1966 |
|
BLAKE2b-256 | c4797d39dd9b72e586fdcb430d3ba6f34fdb106b4e94b417a05d54f87fbe51d5 |
Hashes for pymssql-2.2.2-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ae5c4f582d45fed36bbdc1ebf960f6dbe227c6666e3a927f8c99b76e9e18de7b |
|
MD5 | f15bbd00d6e3f13812aeb5a07352afa6 |
|
BLAKE2b-256 | ab782cf2ecbb379353f77d65add50a3a9185e1832aa6c205c3b3aed867151e04 |
Hashes for pymssql-2.2.2-cp39-cp39-manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 182c6f3a3ba67bf7f750cfce0b3c20abb588b5ae0ffa9387645f0dfd76791b7a |
|
MD5 | 5369336da68422692e4f4d37d82e8a9f |
|
BLAKE2b-256 | f545abce218eb27b7922505b765b77456aa4a0555ebbbe25b9b4b24172ab97e6 |
Hashes for pymssql-2.2.2-cp39-cp39-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 27c4d80c3086ed56ccf93dc03262db7a823d8979dd17e84c8f629a0eeef0526d |
|
MD5 | 05c7389e588645d9bff87089571a2a1e |
|
BLAKE2b-256 | 95c5578c83efb06ef1afc1e919f92b6b74ff22937a7ec024f5e7ff0282b04e12 |
Hashes for pymssql-2.2.2-cp39-cp39-manylinux_2_12_i686.manylinux2010_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0440a138eaac30a449cab497757a849b40c2d0b180b48a8c4151de9bf3bf7e61 |
|
MD5 | a7096e4b8fea953cc4a972decb56644a |
|
BLAKE2b-256 | b811acd42697953e188028fe1e9c3ca83372cd042feb1f7924d77d4e2355ac16 |
Hashes for pymssql-2.2.2-cp39-cp39-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4df67d7c6e2cd99cbf8a1c2d4236a3b81c3bbd7602b95a211ff4da7460ffa83c |
|
MD5 | f3ce3145870c1dff2610c1490dc0b661 |
|
BLAKE2b-256 | def4d00b0c711a34801e31f48544d5430d9df4fd2691c00af9718df7f29647cf |
Hashes for pymssql-2.2.2-cp39-cp39-manylinux_2_5_i686.manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2b8c3bb372a6609f5e46a6702f18bc8370e0f4a53f73ef8559e4a7df58ae4afa |
|
MD5 | ea037d35d92582c21bf5b0b51456dcbe |
|
BLAKE2b-256 | fa238916272a9d214b10460aceaca08537679c340a6db39b99239d003d4f0e09 |
Hashes for pymssql-2.2.2-cp39-cp39-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b243405d6e24a35f123d8a4a3258659fc920a23b2f2b3dbaace097c093f45dba |
|
MD5 | 782c04298595345144adc98c13aa520f |
|
BLAKE2b-256 | 14d9f67f0566183e66c30926072ff4935cca13b6bb2dae62a2255044d96e1dec |
Hashes for pymssql-2.2.2-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 846a90124e4798a5957996653d71b5ec49931c99fe91b5d9f0e73cdca51e85d3 |
|
MD5 | 89f3d18955a803f8b662073d6a62324f |
|
BLAKE2b-256 | 06c26ad1712c0b8147a8a0edd02518dd34a7618dcc255fcc87c674e57ac4a81b |
Hashes for pymssql-2.2.2-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 16907b8d272945ee8861ef13c9657348d2aee1e06434e4a0487988eb1b6938c8 |
|
MD5 | a5263aedbb5e9651ae03f38ea74d63a8 |
|
BLAKE2b-256 | edd8015a3980bec4cef6804fb1831441ff556ae25f6687719e2788187da1f55c |
Hashes for pymssql-2.2.2-cp38-cp38-manylinux_2_24_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7432101f86151a93e77b00c5f36cef0ecd2ac6029d1f9751656647c05ab9ee93 |
|
MD5 | 808ed2c17a841857bdc7fe3687a25eb3 |
|
BLAKE2b-256 | 2843a395cc173f436bbe3f2b5ca1a15e098eb92dc9efa17c1f2dcb0cae75ac5b |
Hashes for pymssql-2.2.2-cp38-cp38-manylinux_2_24_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 463308e52e978d6b7301bbcdf47f866163a57f0783ec0b581e196d7752d05811 |
|
MD5 | 79be24ce2b20968b7f2b8bfeb991700e |
|
BLAKE2b-256 | 0c0e3b2839690a8fb988570ad3cd0702e47cbfe77a800f70581212b7d6defe54 |
Hashes for pymssql-2.2.2-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 71f4eeb68a12981095b62e3170c94a5414f3c428aa90fd7bd3b4ce751d578912 |
|
MD5 | 013d374ed3f5d66aeef97e502afd0ac3 |
|
BLAKE2b-256 | 99aaac3bbe6ef0d0d99896f982be8b1f8fcdabbda79da1e5aa49e2f89de05ae4 |
Hashes for pymssql-2.2.2-cp38-cp38-manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cab9ecb7cec689177955728d116788be27fc65b9d4001ba8e6d8c6e5a5ddf677 |
|
MD5 | d41aa9f44ac11c9538e97891d838eb27 |
|
BLAKE2b-256 | ca2f4ffc5f25dbcc94b1a3f13097bbc1ca4d7b7c647046836dccd37edef269ad |
Hashes for pymssql-2.2.2-cp38-cp38-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f7eedf5b8bd55115a2cab130068b4dccb526fbe8c7bab54468ec31feeb6513d3 |
|
MD5 | 1d775aa2666f567b68c40f4ecb363e16 |
|
BLAKE2b-256 | 42824ef0cb65a19242c4639a91a914e2eefcb353267a2fb563b7b73307e94f86 |
Hashes for pymssql-2.2.2-cp38-cp38-manylinux_2_12_i686.manylinux2010_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a9f28819181b386c45de261c289bdec15f87807d3c03e61b00fa85beffbed621 |
|
MD5 | 4df2f5ecbd76d25ff90a006bdf09f9a8 |
|
BLAKE2b-256 | 3515780446e6a2ee434820e8ec818778346194ca63f65b01b648c18a62c5fe8b |
Hashes for pymssql-2.2.2-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 16d2bd236ef02052b96025d0ca0de436182e36cd95afe7617d8106d2ff7f9485 |
|
MD5 | 727b5d1a59e4719e86c0ad5bcdd54968 |
|
BLAKE2b-256 | bb7b1fe3ad52f2e853674d87bddfcbae6a4e9b437b22475b74a506558846d17d |
Hashes for pymssql-2.2.2-cp38-cp38-manylinux_2_5_i686.manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6988e0e0683fb46b59349927453afc7d75a745aff71d801ebf9ba699e4d815f5 |
|
MD5 | f59fc23d05585daade77a46f1b0da6f2 |
|
BLAKE2b-256 | 75f72b0a706e8cbc1468a637f56d1ffd93cc92563d8c875d7258aaa84e5d0097 |
Hashes for pymssql-2.2.2-cp38-cp38-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 41fbb522decbd7f225f72ac1e2ccf7bb343c58f516ea3165855245b7e22877d2 |
|
MD5 | 6b9ed092cad1978a1298aa4071f97d69 |
|
BLAKE2b-256 | 652b126a1f15e7e07af20137a4b6e2f8ff5c1cdb425cac2a7f83d958c5eb808e |
Hashes for pymssql-2.2.2-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6e37b57d1f0c40c4cee9a75fb55964fc6685d2223dbedf9bd1b87f0274e118cc |
|
MD5 | 5c07b9dd7ac2095f08eb9d5a9d78dc06 |
|
BLAKE2b-256 | 944c8412cb04d0d6738409c75c157ca3355385617a70453e3c6123fb2e9e2e83 |
Hashes for pymssql-2.2.2-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 70a68a95a072199522433b84fe4996157ddb64a1d008435aa54d4b9f004831b7 |
|
MD5 | d51b38317880a0c15c1658ce8190f468 |
|
BLAKE2b-256 | 76235be9f3631069872bb0274db35049d5c85321e369b10e8732b3ac695f2963 |
Hashes for pymssql-2.2.2-cp37-cp37m-manylinux_2_24_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0423cc3b3fc6ea249b13794d727e6e727bc070a14a7840977ae92117d3d091bd |
|
MD5 | ab8715523fffb84ec8cac1fb2aa6ff32 |
|
BLAKE2b-256 | ee258c03a42496686650f2c4e04cfd37064442095e092018787d665e318af977 |
Hashes for pymssql-2.2.2-cp37-cp37m-manylinux_2_24_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 26f365b03893179dee76bb337315d99f4605c1634dd5538ed85dd1822eb41e71 |
|
MD5 | 85257bbb07c04df0fa5cd5660a07bc19 |
|
BLAKE2b-256 | a764b277b08bc7b02c9c50c3a778863d2a64ae4fc6d253875696f51bfc983092 |
Hashes for pymssql-2.2.2-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9987a0af5bc66dd9bd9391ec2f24cbc53bf0bd1ca3f581bc183bfd4ca5ddc204 |
|
MD5 | 77ab869dcc46dd8c0725348ba1b5e03b |
|
BLAKE2b-256 | e85df6fab60a469b97814526000abed9bf993cc40f36a4ffcaeec09280a04961 |
Hashes for pymssql-2.2.2-cp37-cp37m-manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a563cccc730cf25af262a767746451e3b11c243c9fa2c141f23d7a9b3c808ce6 |
|
MD5 | 49d53ca28ebc9987e30978a11f469d4c |
|
BLAKE2b-256 | 12675d5c241594a502c7245c68ecd14f4cd1dfce162321f84e3b6a010291038e |
Hashes for pymssql-2.2.2-cp37-cp37m-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9912b240ca776d7e842b44ed858b4946aaeb1863da9410f3cd4d241afcf0a99f |
|
MD5 | 75977ad1110844558ef9c3e83aaa3f11 |
|
BLAKE2b-256 | 4bf4f1fc664e99efb3b5741127e270b2f4e706bb6759062eb68fb03ae4eae750 |
Hashes for pymssql-2.2.2-cp37-cp37m-manylinux_2_12_i686.manylinux2010_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bd00d3fab48fc931db305e378f706ce73abc8aba0969fdf8fb2ac6df00d6e4ad |
|
MD5 | 8bf359ec0529d89319bd5e2513580ec1 |
|
BLAKE2b-256 | 1453020cc4efdb6a9cc132aac2528807bec8786a82aadf8eb1fa8528bef63a17 |
Hashes for pymssql-2.2.2-cp37-cp37m-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 553e6b7f6fbb1da6167b58a6ed7f8ff5261a073fa04d7b72a8384659c9bcb06f |
|
MD5 | 008120bca870be8b998c00c06225f1ea |
|
BLAKE2b-256 | c868d242995a9c6c188210d8b7d51b5edb91d9207ebfc318d51202e90988cc71 |
Hashes for pymssql-2.2.2-cp37-cp37m-manylinux_2_5_i686.manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 50e81c18aceaf2e254e0085d503451429210896f0d27912fb928329b1eda00cd |
|
MD5 | 7deab3d851bf24385ecc624be9988694 |
|
BLAKE2b-256 | 8897ba301520f5326d49ea5da8227868cedfcef4370fd555bca81eb248a1a7a6 |
Hashes for pymssql-2.2.2-cp37-cp37m-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c3d860cf0e5685675bf06146eb5a0457589580dd04c41571efe940cbc0c2de4e |
|
MD5 | 8dddd701d95155481c69cfcf2affc539 |
|
BLAKE2b-256 | d672f362a8551b9e9d1f4f97b50ff5d823d18f5d11f56a05916cc4a3612419a1 |
Hashes for pymssql-2.2.2-cp36-cp36m-manylinux_2_24_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 494471e3df2f27668f65025be2a62807ea7df4776d5a1717710ce7b5b42a1b6d |
|
MD5 | 74c4dc1db3d2e86f07c10e12ba2f8bfa |
|
BLAKE2b-256 | 10df193ea35b9641a3ac9f65a3499e1c4ef750f3c25bc64d23ff8791db0ab854 |
Hashes for pymssql-2.2.2-cp36-cp36m-manylinux_2_24_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3655b20f08efa9d5127c1d9d2da5d5c7a0206a55e37a0b5e45620c30d7461948 |
|
MD5 | 27f22d5c9e647cedc2c1f50d62838798 |
|
BLAKE2b-256 | 8bdbc5d02d957e95e83d69d40f74c73d621fd4a675adaaddeffabdbbf3195677 |
Hashes for pymssql-2.2.2-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1ab97afa1a5bd7bceb45fb0ab3c6387dfa138752115441babfa4e7988036d4d7 |
|
MD5 | baf8b8c36a034ab260d1cf9199c108eb |
|
BLAKE2b-256 | 3881f5545efbdb701756a1b9956399980a7f77891cd9a1ffd7c8b928d423cd6d |
Hashes for pymssql-2.2.2-cp36-cp36m-manylinux_2_17_i686.manylinux2014_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 03469104efd5e5469b6c1892a0393e1fb4cd3169422e88537bec1b4294c98528 |
|
MD5 | dea41f57e6fa6f58f38cb9c996553430 |
|
BLAKE2b-256 | 051be173e985fbd92e4d47e76a3aa4990ff1e25bb144b119301ea3c894a197a0 |
Hashes for pymssql-2.2.2-cp36-cp36m-manylinux_2_12_x86_64.manylinux2010_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 645e0b90bf969464e1f6868270c81bb1ac2f7b00bc793dc06eed15068f39dfd6 |
|
MD5 | 05bd9c1cec2008ecca9dc7b57f44c816 |
|
BLAKE2b-256 | 135ec155da5342baf7476ac69edc7fd195fb0242c48061e3825a65f16453bc0c |
Hashes for pymssql-2.2.2-cp36-cp36m-manylinux_2_12_i686.manylinux2010_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0fc1723898fba044cd7e63741eb2dfbd09083aca5b9365b88e1757786bb559ac |
|
MD5 | bd956e6db502f76a1755734a0d42a660 |
|
BLAKE2b-256 | 7ed4c66176dc1f8c075fb077d358f6658eaefd0f18bc8d8ae8f8df805a3b9459 |
Hashes for pymssql-2.2.2-cp36-cp36m-manylinux_2_5_x86_64.manylinux1_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 642b423d0f78ec2a5c2fb31ed248399ac43dce2a8abec11b4a9fe0e7f1a38c5d |
|
MD5 | e61902b7974e6ddaa5856239f79003f8 |
|
BLAKE2b-256 | 618619a1bf08a0a6d7eccbece4db46f7123c99642b1379368d8b27d37c5abf27 |
Hashes for pymssql-2.2.2-cp36-cp36m-manylinux_2_5_i686.manylinux1_i686.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 66b121b0ccb38ec240701fd0fd04d8d5923385b03950d930eff1936ec455afe9 |
|
MD5 | 8c04c9e35560c679432fe154b2cee49a |
|
BLAKE2b-256 | befc9d89f21fb0940f34cae36cbad96a9c2bb9d5355e00836d44fcd77c42de2a |