DB API Module for ODBC

Project description

pyodbc

pyodbc is an open source Python module that makes accessing ODBC databases simple. It implements the DB API 2.0 specification but is packed with even more Pythonic convenience.

The easiest way to install is to use pip:

pip install pyodbc

If you are using Mac, you should be using Homebrew for installing pyodbc:

brew install unixodbc
pip install pyodbc

Precompiled binary wheels are provided for most Python versions on Windows and macOS. On other operating systems this will build from source. Note, pyodbc contains C++ extensions so you will need a suitable C++ compiler on your computer to install pyodbc, for all operating systems. See the docs for details.

Documentation

Release Notes

IMPORTANT: Python 2.7 support is being ended. The pyodbc 4.x versions will be the last to support Python 2.7. The pyodbc 5.x versions will only support Python 3.7 and above.

Project details

Release history Release notifications | RSS feed

5.0.0b3 pre-release

Aug 29, 2023

5.0.0b2 pre-release

Aug 28, 2023

5.0.0b1 pre-release

Aug 27, 2023

5.0.0a2 pre-release

Aug 26, 2023

4.0.39

Apr 14, 2023

4.0.38 yanked

Apr 11, 2023

4.0.35

Nov 16, 2022

This version

4.0.34

Jul 14, 2022

4.0.32

Aug 19, 2021

4.0.31

Jul 4, 2021

4.0.30

Feb 8, 2020

4.0.30b1 pre-release

Feb 10, 2020

4.0.28

Dec 21, 2019

4.0.27

Jul 31, 2019

4.0.26

Feb 23, 2019

4.0.25

Dec 14, 2018

4.0.24

Aug 15, 2018

4.0.23

Mar 30, 2018

4.0.22

Jan 19, 2018

4.0.21

Oct 31, 2017

4.0.20

Oct 31, 2017

4.0.19

Oct 23, 2017

4.0.18

Oct 20, 2017

4.0.17

Jun 21, 2017

4.0.16

Mar 30, 2017

4.0.15

Mar 15, 2017

4.0.14

Mar 4, 2017

4.0.13

Feb 25, 2017

4.0.12

Feb 25, 2017

4.0.11

Feb 19, 2017

4.0.10

Feb 19, 2017

4.0.9

Feb 19, 2017

4.0.8

Feb 17, 2017

4.0.7

Feb 16, 2017

4.0.6

Feb 13, 2017

4.0.5

Feb 11, 2017

4.0.3

Jan 20, 2017

4.0.2

Jan 19, 2017

4.0.1

Jan 13, 2017

4.0.0

Dec 30, 2016

3.1.1

Nov 29, 2016

3.0.10

Apr 29, 2015

3.0.9

Apr 28, 2015

3.0.8

Apr 25, 2015

3.0.7

Jul 14, 2013

3.0.6

Jun 24, 2012

3.0.3

Jan 4, 2012

3.0.2

Dec 27, 2011

2.1.11

Sep 14, 2011

2.1.10

Sep 13, 2011

2.1.9

Sep 24, 2015

2.1.8

Sep 6, 2010

2.1.7

Feb 19, 2010

2.1.6

May 24, 2009

2.1.5

Sep 24, 2015

2.1.4

Sep 24, 2015

2.1.3

Dec 31, 2008

2.1.2

Sep 24, 2015

2.1.1

Nov 26, 2008

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pyodbc-4.0.34.tar.gz (271.3 kB view hashes)

Uploaded Jul 14, 2022 source

Built Distributions

pyodbc-4.0.34-cp310-cp310-win_amd64.whl (74.9 kB view hashes)

Uploaded Jul 14, 2022 cp310

pyodbc-4.0.34-cp310-cp310-manylinux_2_24_x86_64.whl (474.6 kB view hashes)

Uploaded Jul 14, 2022 cp310

pyodbc-4.0.34-cp310-cp310-macosx_10_9_x86_64.whl (247.4 kB view hashes)

Uploaded Jul 14, 2022 cp310

pyodbc-4.0.34-cp39-cp39-win_amd64.whl (74.9 kB view hashes)

Uploaded Jul 14, 2022 cp39

pyodbc-4.0.34-cp39-cp39-manylinux_2_24_x86_64.whl (471.7 kB view hashes)

Uploaded Jul 14, 2022 cp39

pyodbc-4.0.34-cp39-cp39-macosx_10_9_x86_64.whl (247.4 kB view hashes)

Uploaded Jul 14, 2022 cp39

pyodbc-4.0.34-cp38-cp38-win_amd64.whl (75.1 kB view hashes)

Uploaded Jul 14, 2022 cp38

pyodbc-4.0.34-cp38-cp38-manylinux_2_24_x86_64.whl (475.1 kB view hashes)

Uploaded Jul 14, 2022 cp38

pyodbc-4.0.34-cp38-cp38-macosx_10_9_x86_64.whl (247.5 kB view hashes)

Uploaded Jul 14, 2022 cp38

pyodbc-4.0.34-cp37-cp37m-win_amd64.whl (75.3 kB view hashes)

Uploaded Jul 14, 2022 cp37

pyodbc-4.0.34-cp37-cp37m-manylinux_2_24_x86_64.whl (472.1 kB view hashes)

Uploaded Jul 14, 2022 cp37

pyodbc-4.0.34-cp37-cp37m-macosx_10_9_x86_64.whl (247.5 kB view hashes)

Uploaded Jul 14, 2022 cp37

pyodbc-4.0.34-cp36-cp36m-win_amd64.whl (75.3 kB view hashes)

Uploaded Jul 14, 2022 cp36

pyodbc-4.0.34-cp36-cp36m-manylinux_2_24_x86_64.whl (464.5 kB view hashes)

Uploaded Jul 14, 2022 cp36

pyodbc-4.0.34-cp36-cp36m-macosx_10_9_x86_64.whl (247.4 kB view hashes)

Uploaded Jul 14, 2022 cp36

Hashes for pyodbc-4.0.34.tar.gz

Hashes for pyodbc-4.0.34.tar.gz
Algorithm	Hash digest
SHA256	`7ea7869532b96b8d529b1f08ea85765f94df7e4a58e968b2f8d455346a03e45c`
MD5	`12fd23a5b621eb44ba3fb41b3a60bea2`
BLAKE2b-256	`1cc3b40c1e33fe5285158bf15e6eedd7bdbb929a250d4f4ed435bb1a62a8f1a3`

Hashes for pyodbc-4.0.34-cp310-cp310-win_amd64.whl

Hashes for pyodbc-4.0.34-cp310-cp310-win_amd64.whl
Algorithm	Hash digest
SHA256	`befe795303ff13d55fa15c42496aa414cd60f465e8d96daec8c9b48bfea2c1ec`
MD5	`e362e6ddc3cc004e857c47f55e5d9486`
BLAKE2b-256	`e2888bb9d9a1f9e59faa7bec432781c0dacc7e1eadc83f147ea7e109350481f8`

Hashes for pyodbc-4.0.34-cp310-cp310-manylinux_2_24_x86_64.whl

Hashes for pyodbc-4.0.34-cp310-cp310-manylinux_2_24_x86_64.whl
Algorithm	Hash digest
SHA256	`9d8ca2122c2671264d53f0009e4c96b80b4da9bd44394e6ef6692b3aeb34be7c`
MD5	`2585d478bbb9451cc050200a1bdf3b21`
BLAKE2b-256	`9f338e97f629e8b15c2b1b52e172ab14ffdccb6ebcd9b46b806159c78032e296`

Hashes for pyodbc-4.0.34-cp310-cp310-macosx_10_9_x86_64.whl

Hashes for pyodbc-4.0.34-cp310-cp310-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`07caafd49335e444f66d7ac78a87ffd1b8ce71d352b5bf0ffaa93d9ea82b003b`
MD5	`e211e3319f1f565977a580ebc00ac40c`
BLAKE2b-256	`3421423e970582be708d824fb4c65ffb93933a040576295192c284dc06de638a`

Hashes for pyodbc-4.0.34-cp39-cp39-win_amd64.whl

Hashes for pyodbc-4.0.34-cp39-cp39-win_amd64.whl
Algorithm	Hash digest
SHA256	`eb7a1a15eb35322e62bfb1c2910274106781edf4dc268ad2b0e9fc89958689e4`
MD5	`9cded651e14514b0ab696a3784315b71`
BLAKE2b-256	`8accd67461ad9b73d75a8c2d9b2e766d9d1da9c26f19feb1940984a0a141d3b1`

Hashes for pyodbc-4.0.34-cp39-cp39-manylinux_2_24_x86_64.whl

Hashes for pyodbc-4.0.34-cp39-cp39-manylinux_2_24_x86_64.whl
Algorithm	Hash digest
SHA256	`e8244184fd7b92cafbdb417709a214371fe489d6fed97e61d130ceb2891f5e52`
MD5	`dabcf05e7335d8fc3d392b3922416ed5`
BLAKE2b-256	`8170b7c2a78b06a28d1a0e11a4d51a74f434e8609549e32d838a1ec6065174c0`

Hashes for pyodbc-4.0.34-cp39-cp39-macosx_10_9_x86_64.whl

Hashes for pyodbc-4.0.34-cp39-cp39-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`402e94519ee95ae7ce0a792fc37fc3922f8a970337edc873b03d64427815ac8f`
MD5	`1e183928af6b0633651a609f210c9cbc`
BLAKE2b-256	`5d29689bc01d2be902df0b9048b917481007d5eee50db7a71b4bc70759c373b3`

Hashes for pyodbc-4.0.34-cp38-cp38-win_amd64.whl

Hashes for pyodbc-4.0.34-cp38-cp38-win_amd64.whl
Algorithm	Hash digest
SHA256	`c8d95528d0c33fb24d0928d8cfe7dd194f7406a3da9c4a73b6fcb203b66addd4`
MD5	`cc51ec01103aa73f1ffcf6e77c054539`
BLAKE2b-256	`3b7447706d8f9f469965cc63d9d62d1ec21b17bfa594f30dc0280c1cddd47bf1`

Hashes for pyodbc-4.0.34-cp38-cp38-manylinux_2_24_x86_64.whl

Hashes for pyodbc-4.0.34-cp38-cp38-manylinux_2_24_x86_64.whl
Algorithm	Hash digest
SHA256	`5e454fe5ac21d5a920e2d1f269c38e2af2d045ea97979951953f57f41ac8cea0`
MD5	`a3f8c785c8037c5ad598457d924ce02f`
BLAKE2b-256	`625a07aa32e4cf58a0459bc99ac1d9b7d2cf2a2b9f391963c3a8cbc1a9424632`

Hashes for pyodbc-4.0.34-cp38-cp38-macosx_10_9_x86_64.whl

Hashes for pyodbc-4.0.34-cp38-cp38-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`5eda44df6c064d43075ced640d955399a663523028a847132a50fc02722c4904`
MD5	`2af46afd63c9b6f74958c4a82624c02b`
BLAKE2b-256	`0dd644109a535d8a7e30af9f1403ab475008b51893992faec083820b9f5d2756`

Hashes for pyodbc-4.0.34-cp37-cp37m-win_amd64.whl

Hashes for pyodbc-4.0.34-cp37-cp37m-win_amd64.whl
Algorithm	Hash digest
SHA256	`2ad077231c6f33555abd6e482ce027739c54430b973477a42094fbae2f3d9791`
MD5	`45a2fd444d24f7ab05d7912b7ec0f79e`
BLAKE2b-256	`7ba2468678f01bb28c1bc4bc71a13a505f32e83f8d6b3347e34b6c0134e91c20`

Hashes for pyodbc-4.0.34-cp37-cp37m-manylinux_2_24_x86_64.whl

Hashes for pyodbc-4.0.34-cp37-cp37m-manylinux_2_24_x86_64.whl
Algorithm	Hash digest
SHA256	`9b2bb29121971b3316faeb2593e59f6f9faebd85048b4f0716b46c6282c1b9a8`
MD5	`879c7c033a185594b3ff24a4c4f13519`
BLAKE2b-256	`70a4e67942a2e79fb55491226bfdb5fc26678ecd382b0f2e150eff26cc65918d`

Hashes for pyodbc-4.0.34-cp37-cp37m-macosx_10_9_x86_64.whl

Hashes for pyodbc-4.0.34-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`b80aee02983130cf0087234d226e2310b527d093402b60d307f2b90dc038ff65`
MD5	`f221f6ffa654cd98507940334fe929b8`
BLAKE2b-256	`13634a0b0b4e095f3c8c2c83b5ffba65fff8b5500d73ed1c44bc1d20f7dcd836`

Hashes for pyodbc-4.0.34-cp36-cp36m-win_amd64.whl

Hashes for pyodbc-4.0.34-cp36-cp36m-win_amd64.whl
Algorithm	Hash digest
SHA256	`991c1441b5067e88c37f32eb79b4015fda6b5451b396187325ec594bd4d5ae74`
MD5	`bd00d525006b2a06ab727121071a94b4`
BLAKE2b-256	`258625845cb48f8813b3593a5d98fcb850c4a7232ac4b4e1694cea4c8d89bd88`

Hashes for pyodbc-4.0.34-cp36-cp36m-manylinux_2_24_x86_64.whl

Hashes for pyodbc-4.0.34-cp36-cp36m-manylinux_2_24_x86_64.whl
Algorithm	Hash digest
SHA256	`5a400524ad64dcd242ea75070789696f7157e23597767340307494e4b85c5a8e`
MD5	`9f0aae49cca216df838b980553ca41fb`
BLAKE2b-256	`19efe4f79769022b1a1f0dee4ddbb3fd352005f9a947511905f9d293b61f37d8`

Hashes for pyodbc-4.0.34-cp36-cp36m-macosx_10_9_x86_64.whl

Hashes for pyodbc-4.0.34-cp36-cp36m-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`5502d98e7bb37d6407e97ecd9f6528e9512439c7c3ff6f444d8b4b59ebb5ef4b`
MD5	`dd19ab9555cdd993a633a15c56abcf66`
BLAKE2b-256	`833c9c0dac8c154f04c03289a200717c0dd16e586913f31a2290b45598332585`