DB API Module for ODBC

These details have not been verified by PyPI

Project links

Homepage

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 pyodbc is to use pip:

pip install pyodbc

On Macs, you should probably install unixODBC first if you don't already have an ODBC driver manager installed, e.g. using Homebrew:

brew install unixodbc
pip install pyodbc

Similarly, on Unix you should make sure you have an ODBC driver manager installed before installing pyodbc. See the docs for more information about how to do this on different Unix flavors. (On Windows, the ODBC driver manager is built-in.)

Precompiled binary wheels are provided for multiple Python versions on most Windows, macOS, and Linux platforms. On other platforms pyodbc will be built from the source code. Note, pyodbc contains C++ extensions so when building from source you will need a suitable C++ compiler. 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 support only Python 3.7 and above.

Project details

These details have not been verified by PyPI

Project links

Homepage

Release history Release notifications | RSS feed

5.2.0

Oct 16, 2024

5.1.0

Feb 5, 2024

5.0.1

Oct 13, 2023

5.0.0

Oct 10, 2023

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

This version

4.0.39

Apr 14, 2023

4.0.38 yanked

Apr 11, 2023

Reason this release was yanked:

Critical bug in Row.__repr__

4.0.35

Nov 16, 2022

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.39.tar.gz (282.4 kB view details)

Uploaded Apr 14, 2023 Source

Built Distributions

pyodbc-4.0.39-cp311-cp311-win_amd64.whl (69.7 kB view details)

Uploaded Apr 14, 2023 CPython 3.11 Windows x86-64

pyodbc-4.0.39-cp311-cp311-win32.whl (62.8 kB view details)

Uploaded Apr 14, 2023 CPython 3.11 Windows x86

pyodbc-4.0.39-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (352.6 kB view details)

Uploaded Apr 14, 2023 CPython 3.11 manylinux: glibc 2.17+ x86-64

pyodbc-4.0.39-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (349.4 kB view details)

Uploaded Apr 14, 2023 CPython 3.11 manylinux: glibc 2.17+ ARM64

pyodbc-4.0.39-cp311-cp311-macosx_11_0_arm64.whl (72.6 kB view details)

Uploaded Apr 14, 2023 CPython 3.11 macOS 11.0+ ARM64

pyodbc-4.0.39-cp311-cp311-macosx_10_9_x86_64.whl (73.2 kB view details)

Uploaded Apr 14, 2023 CPython 3.11 macOS 10.9+ x86-64

pyodbc-4.0.39-cp310-cp310-win_amd64.whl (69.7 kB view details)

Uploaded Apr 14, 2023 CPython 3.10 Windows x86-64

pyodbc-4.0.39-cp310-cp310-win32.whl (62.9 kB view details)

Uploaded Apr 14, 2023 CPython 3.10 Windows x86

pyodbc-4.0.39-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (343.5 kB view details)

Uploaded Apr 14, 2023 CPython 3.10 manylinux: glibc 2.17+ x86-64

pyodbc-4.0.39-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (342.2 kB view details)

Uploaded Apr 14, 2023 CPython 3.10 manylinux: glibc 2.17+ ARM64

pyodbc-4.0.39-cp310-cp310-macosx_11_0_arm64.whl (72.6 kB view details)

Uploaded Apr 14, 2023 CPython 3.10 macOS 11.0+ ARM64

pyodbc-4.0.39-cp310-cp310-macosx_10_9_x86_64.whl (73.1 kB view details)

Uploaded Apr 14, 2023 CPython 3.10 macOS 10.9+ x86-64

pyodbc-4.0.39-cp39-cp39-win_amd64.whl (69.8 kB view details)

Uploaded Apr 14, 2023 CPython 3.9 Windows x86-64

pyodbc-4.0.39-cp39-cp39-win32.whl (62.9 kB view details)

Uploaded Apr 14, 2023 CPython 3.9 Windows x86

pyodbc-4.0.39-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (340.6 kB view details)

Uploaded Apr 14, 2023 CPython 3.9 manylinux: glibc 2.17+ x86-64

pyodbc-4.0.39-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (337.2 kB view details)

Uploaded Apr 14, 2023 CPython 3.9 manylinux: glibc 2.17+ ARM64

pyodbc-4.0.39-cp39-cp39-macosx_11_0_arm64.whl (72.6 kB view details)

Uploaded Apr 14, 2023 CPython 3.9 macOS 11.0+ ARM64

pyodbc-4.0.39-cp39-cp39-macosx_10_9_x86_64.whl (73.1 kB view details)

Uploaded Apr 14, 2023 CPython 3.9 macOS 10.9+ x86-64

pyodbc-4.0.39-cp38-cp38-win_amd64.whl (69.7 kB view details)

Uploaded Apr 14, 2023 CPython 3.8 Windows x86-64

pyodbc-4.0.39-cp38-cp38-win32.whl (63.0 kB view details)

Uploaded Apr 14, 2023 CPython 3.8 Windows x86

pyodbc-4.0.39-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (345.6 kB view details)

Uploaded Apr 14, 2023 CPython 3.8 manylinux: glibc 2.17+ x86-64

pyodbc-4.0.39-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (344.1 kB view details)

Uploaded Apr 14, 2023 CPython 3.8 manylinux: glibc 2.17+ ARM64

pyodbc-4.0.39-cp38-cp38-macosx_11_0_arm64.whl (72.7 kB view details)

Uploaded Apr 14, 2023 CPython 3.8 macOS 11.0+ ARM64

pyodbc-4.0.39-cp38-cp38-macosx_10_9_x86_64.whl (73.1 kB view details)

Uploaded Apr 14, 2023 CPython 3.8 macOS 10.9+ x86-64

pyodbc-4.0.39-cp37-cp37m-win_amd64.whl (71.0 kB view details)

Uploaded Apr 14, 2023 CPython 3.7m Windows x86-64

pyodbc-4.0.39-cp37-cp37m-win32.whl (64.3 kB view details)

Uploaded Apr 14, 2023 CPython 3.7m Windows x86

pyodbc-4.0.39-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (336.2 kB view details)

Uploaded Apr 14, 2023 CPython 3.7m manylinux: glibc 2.17+ x86-64

pyodbc-4.0.39-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (333.9 kB view details)

Uploaded Apr 14, 2023 CPython 3.7m manylinux: glibc 2.17+ ARM64

pyodbc-4.0.39-cp37-cp37m-macosx_10_9_x86_64.whl (72.8 kB view details)

Uploaded Apr 14, 2023 CPython 3.7m macOS 10.9+ x86-64

pyodbc-4.0.39-cp36-cp36m-win_amd64.whl (79.2 kB view details)

Uploaded Apr 14, 2023 CPython 3.6m Windows x86-64

pyodbc-4.0.39-cp36-cp36m-win32.whl (70.4 kB view details)

Uploaded Apr 14, 2023 CPython 3.6m Windows x86

pyodbc-4.0.39-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (330.5 kB view details)

Uploaded Apr 14, 2023 CPython 3.6m manylinux: glibc 2.17+ x86-64

pyodbc-4.0.39-cp36-cp36m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (327.4 kB view details)

Uploaded Apr 14, 2023 CPython 3.6m manylinux: glibc 2.17+ ARM64

pyodbc-4.0.39-cp36-cp36m-macosx_10_9_x86_64.whl (72.8 kB view details)

Uploaded Apr 14, 2023 CPython 3.6m macOS 10.9+ x86-64

File details

Details for the file pyodbc-4.0.39.tar.gz.

File metadata

Download URL: pyodbc-4.0.39.tar.gz
Upload date: Apr 14, 2023
Size: 282.4 kB
Tags: Source
Uploaded using Trusted Publishing? No
Uploaded via: twine/4.0.0 CPython/3.10.6

File hashes

Hashes for pyodbc-4.0.39.tar.gz
Algorithm	Hash digest
SHA256	`e528bb70dd6d6299ee429868925df0866e3e919c772b9eff79c8e17920d8f116`
MD5	`166d56f3e9524ac5c8f5bf06af1e7193`
BLAKE2b-256	`b780835b8a98089e31aa6b9bfc0301c1546e69f5205a966888f2663e43e7d07b`

Algorithm	Hash digest
SHA256	`3d9d70e1635d35ba3aee3df216ec8e35f2824909f43331c0112b17f460a93923`
MD5	`35db661005589a2a3bf538ad99f4b86a`
BLAKE2b-256	`9a9d588b435abbe8f26f7d1d3c79de75fe2ec463d39828c6db1eadb857fc0d5c`

Algorithm	Hash digest
SHA256	`f792677b88e1dde12dab46de8647620fc8171742c02780d51744f7b1b2135dbc`
MD5	`708cab7b1aadb4099c9511b354bbfaec`
BLAKE2b-256	`22b817a7c140f3683561e0022232cb3399b56d3b3d1d8ff80d5334301ff2dfc0`

Algorithm	Hash digest
SHA256	`400e911d54980098c6badadecc82385fc0d6a9057db525d63d2652317df43efe`
MD5	`f59e89dde7abdee81955bcc494942a4b`
BLAKE2b-256	`918319a16da6a4ed3d514d114845e076f6e0877f474cf90346691942881a0fb7`

Algorithm	Hash digest
SHA256	`5ec009180fcd7c8197f45d083e6670623d8dfe198a457ca2a50ebb1bafe4107f`
MD5	`f88cfbebbd2d0ffa8fe34f6cae09b483`
BLAKE2b-256	`6c9a6e0ffaf73641a232f46daeb3eb07dde4e35cf712e5eb6cd0f274b1fac2e5`

Algorithm	Hash digest
SHA256	`1f7fb65191926308f09ce75ae7ccecf89310232ee50cdea74edf17ee04a9b068`
MD5	`8276a2dbad26a5b14ec2205ac8e2df42`
BLAKE2b-256	`6479417938746f3d0b45963ac1560372557365765bf05e34a95b111c5fcfb8f3`

Algorithm	Hash digest
SHA256	`530c1ac37ead782803b44fb1934ba4c68ed4a6969f7475cb8bc04ae1da14486e`
MD5	`cab8c913fb899fdfe81041ecdb08d21e`
BLAKE2b-256	`46459565521b6ed86f3e568b55dc6a55e844e918f425240c9e35147dc05ed649`

Algorithm	Hash digest
SHA256	`8eb5547282dc73a7784ce7b99584f68687dd85543538ca6f70cffaa6310676e7`
MD5	`6719d2df13141c5b6f842b07b5121cf0`
BLAKE2b-256	`b14d832a5e27fe69677b6bdda346e5d8fc3985e420838b53afac557dc3f95b26`

Algorithm	Hash digest
SHA256	`62bb6d7d0d25dc75d1445e539f946461c9c5a3643ae14676b240f71794ea004f`
MD5	`b675c01034208095cce5d74a77ab0f83`
BLAKE2b-256	`2b6d49a8ae75433b6d5fa50a18f1ece4656e3a6deae8bcf3cf4b5e9b71fd04ae`

Algorithm	Hash digest
SHA256	`c5faf2870e9d434c6a85c6adc1cdff55c0e376273baf480f06d9848025405688`
MD5	`0e4ec249a6a0b052cb59af22b49f0332`
BLAKE2b-256	`24591a657510e6dd058c74df3b3a4d8af51d724f21db34f10b4f3ac484bedb91`

Algorithm	Hash digest
SHA256	`e0db69478d00fcd8d0b9bdde8aca0b0eada341fd6ed8c2da84b594b928c84106`
MD5	`3cafd1e36b65044649576770b595e1ea`
BLAKE2b-256	`c7a93548d754d5f42ae61d6ae39c2fe3cee05d39502ac9738b2e260331578df9`

Algorithm	Hash digest
SHA256	`0f5901b57eaef0761f4cf02bca8e7c63f589fd0fd723a79f6ccf1ea1275372e5`
MD5	`6ff564b33a75a759dc98fc080aa74f92`
BLAKE2b-256	`ba86ccf89c43ed691efac29e0f1c97a797567ae2982c64303b4762b4422fdbf0`

Algorithm	Hash digest
SHA256	`74af348dbaee4885998858daf50c8964e767629ecf6c195868b016367b0bb861`
MD5	`270a0c3352e96c734448017a76fea862`
BLAKE2b-256	`1cc0c85eaec65c71de68272b5fb29f354ca720f679170a214eca5da2ae6ebf72`

Algorithm	Hash digest
SHA256	`305c7d6337e2d4c8350677cc641b343fc0197b7b9bc167815c66b64545c67a53`
MD5	`7ff0194bf534a0ee910e97231bc99780`
BLAKE2b-256	`ef8e5d90a8aed75000b4679e854a3acbcc3f0a310def3728e7183f4d174a4409`

Algorithm	Hash digest
SHA256	`42649ed57d09c04aa197bdd4fe0aa9ca319790b7aa86d0b0784cc70e78c426e5`
MD5	`fc9cf78f14c1162747769caf42740d80`
BLAKE2b-256	`2e0ab4ff9dd77b68f4d2a99190c085433bda8fe1199536a7e09a87d78442bf48`

Algorithm	Hash digest
SHA256	`fe4ee87b88867867f582dd0c1236cd982508db359a6cbb5e91623ceb6c83e60a`
MD5	`e29413be54b8efe1cec2fc1d7f893849`
BLAKE2b-256	`d6b56c53edb0bd66f3fe3622a850f67702376aebfb546454f3b0f434a4d7e84a`

Algorithm	Hash digest
SHA256	`cdf5a27e6587d1762f7f0e35d6f0309f09019bf3e19ca9177a4b765121f3f106`
MD5	`3c7dee13db6eb45a44dc67e4adaa2198`
BLAKE2b-256	`ad66cd05e73a2020cd96a6e5e3bfb791509c65fdc96d732377ddb1fe981649d1`

Algorithm	Hash digest
SHA256	`a6f4067f46aaa78e77e8a15ade81eb21fb344563d245fb2d9a0aaa553c367cbd`
MD5	`c62610bd8391d7970e99f1bb5235f48b`
BLAKE2b-256	`40f6238037a45a406c90ec1ab30eb8065396068c9ab9ece5bf2d9c9743a7667e`

Algorithm	Hash digest
SHA256	`9253e746c5c94bf61e3e9adb08fb7688d413cb68c06ebb287ec233387534760a`
MD5	`c1587f760ca67a51581a3c9fdb6922ad`
BLAKE2b-256	`790f794f01b9d8bca5bb052b45728f23bc2e4beac430182734eebdb9662d9bd0`

Algorithm	Hash digest
SHA256	`8553eaef9f8ec333bbddff6eadf0d322dda34b37f4bab19f0658eb532037840c`
MD5	`221e18ccdc82b4302e1c5f8ce8a0e28c`
BLAKE2b-256	`e2cd85546739b8b37df8fb77b388aa7f03562e17aa53c93dd16f2ebf11e5beeb`

Algorithm	Hash digest
SHA256	`a591a1cf3c251a9c7c1642cfb3774119bf3512f3be56151247238f8a7b22b336`
MD5	`1b1f7e0862759b41aacbb20a9929fc7a`
BLAKE2b-256	`2526cf53655fa074176409812c40db56930881be7c69bc26924ab9abc4ff9a67`

pyodbc 4.0.39

Navigation

Verified details

Maintainers

Unverified details

Project links

Meta

Classifiers

Project description

pyodbc

Project details

Verified details

Maintainers

Unverified details

Project links

Meta

Classifiers

Release history Release notifications | RSS feed

Download files

Source Distribution

Built Distributions

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

Algorithm	Hash digest
SHA256	`6353044b99c763aeec7ca1760b4340298504d8ee544fdcab3c380a2abec15b78`
MD5	`c4c5100ff3ff55004a7ad5ab00fbd57c`
BLAKE2b-256	`d332e4020af6a4ae956c0b3d297ddb876f820907fd58287edfe23d371fa7f670`

Algorithm	Hash digest
SHA256	`05a0912e852ebddaffa8f235b0f3974475021dd8eb604eb46ea67af06efe1239`
MD5	`519e7795cca715e260eb3527c835db07`
BLAKE2b-256	`b13c410b10240a05b521e800ad927cff0c5cfcf25f156f180b9b73f03adb604a`

Algorithm	Hash digest
SHA256	`a3e133621ac2dad22d0870a8521c7e82d4270e24ce02451d64e7eb6a40ad0941`
MD5	`bcee7d269812c2de0dfe45d27a2ffcb0`
BLAKE2b-256	`e992a99b93cb4bea4c852e6fc3d1cc51bc28acfdee7354225312379315b91796`

Algorithm	Hash digest
SHA256	`ebcb900fcaf19ca2bc38632218c5d48c666fcc19fe38b08cde001917f4581456`
MD5	`429cad64f2c2d86cbb95a93471c9d697`
BLAKE2b-256	`0e01bc0da2c8f4f529320870b844290aff26a40edfdb27b465efee76d177c49e`

Algorithm	Hash digest
SHA256	`39f6c56022c764309aa7552c0eb2c58fbb5902ab5d2010d42b021c0b205aa609`
MD5	`636896dc2fc3b290503c6429fb6ffd4f`
BLAKE2b-256	`b1f45e685f1d0df25877ef728edc99423f94629d810be452b01beae14432de37`

Algorithm	Hash digest
SHA256	`72d364e52f6ca2417881a23834b3a36733c09e0dcd4760f49a6b864218d98d92`
MD5	`a04e2c4d7c6ebb3b12d680210c7325e9`
BLAKE2b-256	`98370a4644fe87b801361dd386f623781fa10e6f09b7fc22fb87bda00c4c22e1`

Algorithm	Hash digest
SHA256	`b36fe804d367d01ad81077fa524a36e667aabc3945e32564c7ef9595b28edfa9`
MD5	`61f4c12a3b7aa47853469690fc7a59cc`
BLAKE2b-256	`fa95f78a36467cf613bb08a1b5ef9eb9ad3b7958361dee2a04bb17daa674a6c6`

Algorithm	Hash digest
SHA256	`ea08e9379c08663d7260e2b8a6c451f56d36c17291af735191089f8e29ad9578`
MD5	`6bd4238d97ea691f9a2da7b1d1a5c78c`
BLAKE2b-256	`9f7bad4b36e4dfe8a28089da12d9e601733e7704950ebc5bc289e96e0ccc6f30`

Algorithm	Hash digest
SHA256	`efccc11dff6fba684a74ae1030c92ff8b82429d7f00e0a50aa2ac6f56621cd9f`
MD5	`f002628bf70b007f13837cb2fd8b5657`
BLAKE2b-256	`039b37783d0b74b0597c40bdc414f64cd979754eb532a9eea3bcb116f5d0f2bb`

Algorithm	Hash digest
SHA256	`27d1b3c3159673b44c97c878f9d8056901d45f747ce2e0b4d5d99f0fb6949dc7`
MD5	`274978d185d9d7097216ca13b17260cb`
BLAKE2b-256	`5be01f61a87328f2abfbaeaec1aef174a752f818756d6ae4665dae890c92dabc`