DB API Module for ODBC
Reason this release was yanked:
Critical bug in Row.__repr__
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.
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
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 pyodbc-4.0.38-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 620aa68e73caefa84f762d3f51b709a4eadb62df5d0feaf41f0edc4ff6553e04 |
|
MD5 | 848e35c32cac1e6f7a5922ab779e49e0 |
|
BLAKE2b-256 | 37e1c168579083fb64ecaece8f2e16ff6e6056a025e878531945aef18a1636fc |
Hashes for pyodbc-4.0.38-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f897fe4ccc348e777c4d4be066228543c3d894219e272c47cc161ad5b517964a |
|
MD5 | 48ec5c1a907555cdb8f2b393825a933e |
|
BLAKE2b-256 | 4f0c90420effe0add3964920491e0f5afeaa9c0762cdcdb6c8de1c140c2ff9c3 |
Hashes for pyodbc-4.0.38-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 661fe8d82357f005f8103141528a6eb99188b65d8656365c1c6f9e9f0f95e174 |
|
MD5 | 13b19d88a3dfdcd6691204edbb614efc |
|
BLAKE2b-256 | b6da6ffb30042ff9f3e8dab4e9e7bd9b7948e6f145c5312aea92758970cabda9 |
Hashes for pyodbc-4.0.38-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 22af4364419dc02ab1938309b8343145a079b26fd0e7f5458e4bec4a35d5b535 |
|
MD5 | f45f35c3537968ae75311726abc7a9d8 |
|
BLAKE2b-256 | a8ca45493a61bfa7fa2fe05ce42bff1aca3ce6d6c3f9bdd99a332e7f760c1f90 |
Hashes for pyodbc-4.0.38-cp311-cp311-macosx_11_0_arm64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f146d3f406883ce40a64c392172f945b0a7638f59bcd8799100ecbd0b183b3d2 |
|
MD5 | 62ffa0159b8dd9314d2466e3224b3aab |
|
BLAKE2b-256 | 508fb23d70d1cb65367c076a7a7601b55b589be80f97ce1d436f5bebee1ea092 |
Hashes for pyodbc-4.0.38-cp311-cp311-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | da7ebe90c28999b89ac2b5e8169d317870cd90cf6ea6475f4437a19b239751fe |
|
MD5 | 6e97375e5cd32ab61a6a47c33256650c |
|
BLAKE2b-256 | 702762ea2da0af76da37ef542d780dc49fa06792a8d5177e3e33957bbfea60e8 |
Hashes for pyodbc-4.0.38-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | da2388ddff5ccaa28acfb34c47aeee4c99ece44880b6729a37019b651eed4cc0 |
|
MD5 | 1a24d097c4dfe34729ac8317295d50b7 |
|
BLAKE2b-256 | 49a9885264baaeaa29b66a5a7a299f6bbdf28b3a112b5721cf9ef6491b4926ae |
Hashes for pyodbc-4.0.38-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 23429dc9f4156ca7e8f3a1b515008c18f22bc8569f1a8e026292d69cc514c66f |
|
MD5 | ffd3a42eee4c296f106368428b811dcf |
|
BLAKE2b-256 | a9b85c53f575e0980bb94276514fe723dcb4c521d1d03b80fb05be6eb9774a18 |
Hashes for pyodbc-4.0.38-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bbb3a6e79e18829675dc4de65ac7fcf24a1c19eb2692ccbf94f65ee41840f299 |
|
MD5 | add52742e5bf12d26e06acb0608f1975 |
|
BLAKE2b-256 | 3787f36b9954d076bb9b5e57f6a2a12e5a8ade581916dfbe60cf273816106045 |
Hashes for pyodbc-4.0.38-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0a5fedd967345cd138dbfdb4e2633df105fc1a6fe0cfce790c62827ac18cee79 |
|
MD5 | cd361653dba1ea054e589e5f5c8b12dc |
|
BLAKE2b-256 | aa06991e6f49092a4fb158f1565334a739e64486a41abfc20a392dafaef476df |
Hashes for pyodbc-4.0.38-cp310-cp310-macosx_11_0_arm64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 16c6301150ec1993c19381c6ec7982fa9ac75d72d8e9ed2ddb48b8eef9d1cde7 |
|
MD5 | f3049cf093074124dfcfd9aaf398cd9d |
|
BLAKE2b-256 | 59d2e2049cf04b7926d4fcae1e4308f395e3a9c2c5f3cfb75613e4996772a42a |
Hashes for pyodbc-4.0.38-cp310-cp310-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 04fdd0f121389e5f5b38dc0c583b5c0a55979accb3097bc9ba6b71508cb19c24 |
|
MD5 | 8e5f2d5a9945d6b8ed580e9db75aac5a |
|
BLAKE2b-256 | 3bc145c7eb41b197c79b86c223ba6d1debb4d7d666e0e186ce4a8fb4e71b22d0 |
Hashes for pyodbc-4.0.38-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c15b3588fe6b1b8bddd141e1818bc8dcbe14c20d798197141ea2ddb0b90079d7 |
|
MD5 | a965f92a43aeba9bec07386cc3d7dffa |
|
BLAKE2b-256 | 6b7336881f37f6ca44c9a7ad3b3bd5a762978352a0e1cdd645daca0db265c3a2 |
Hashes for pyodbc-4.0.38-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8fa6752838f1b950bc1658036e9059d8e2b0c2749d32a10ee15c5c48e85eed70 |
|
MD5 | 27a2560043b61762638abbc63297cb4e |
|
BLAKE2b-256 | d41c70ed78dfe59c3c24d9d3541805b1e0055153958525e7c1885d0c58b2338b |
Hashes for pyodbc-4.0.38-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f9224a39ea2c6fe6ce491923edd058e0b817a61846adf9842491c3ee0d08efd5 |
|
MD5 | 40a881aa34812d357f07eb75c09ea6b0 |
|
BLAKE2b-256 | 08b7dbdb18a2c986f62c195a53351988748388024fa5fa851fa6ad385d5d6fab |
Hashes for pyodbc-4.0.38-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 51eb274ed16a1094fb50c64bb7a0bdc763346f3a8d7420923e9b946c01e3cc81 |
|
MD5 | 4ee74a255cc5aefc16e4287bd463d328 |
|
BLAKE2b-256 | 757f959a4e8d4b45d8d8ec274d82f6be673f13ec80c5620abb916e6785b97120 |
Hashes for pyodbc-4.0.38-cp39-cp39-macosx_11_0_arm64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 395fae6d2b4c26c2c93e4a4d2ac051dbfbfc37dd55312a458822115947003949 |
|
MD5 | 8bd6f8739a10674b8f3946ea3b525993 |
|
BLAKE2b-256 | b984f78822060652a344c78f03e50a915820f84c0f5cc021c9ca3e419e463466 |
Hashes for pyodbc-4.0.38-cp39-cp39-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 025968ab8932e47f7508c4cc971001077ac1f17756877d0711a319e99e953215 |
|
MD5 | 7a5e22e356c70f5fca97bc81ef3ac18a |
|
BLAKE2b-256 | 2098a7a76c8e35ee87fd8cf39284172491a70a66b64875bfa4f3735b0fd5f338 |
Hashes for pyodbc-4.0.38-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 278317d4c85bf66f31a86518c2fe81e68b9eb1a2a5bbd7315cce7bd8838a550c |
|
MD5 | 8fa5125f83ab6d3ef3234a170c8859c8 |
|
BLAKE2b-256 | 49fde8f5b9beb3794548712dbadf184a1460446cae2901caf61fd602233879a1 |
Hashes for pyodbc-4.0.38-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6eb903dfddbc9ee85074d2d66da56c272fcae2dba912b0173e44a4dd2708efbc |
|
MD5 | d6b9edd416c10e3d90439a47061b4352 |
|
BLAKE2b-256 | 623fde6b201cf16e1cf2b5a4cc5ab3bfe0a51a738e60420ffcfa9d6194ea9336 |
Hashes for pyodbc-4.0.38-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c5ccff8909c73eef783b557a782b78861b5f1b7429d868209cc040c9595f580c |
|
MD5 | 6ef3c08f79cb59ac87d04dcf8240dfbe |
|
BLAKE2b-256 | 044df7027f7d391c0d37e31924b2e9c24e6cea5e190b890fb428f1f9d7d3dcaf |
Hashes for pyodbc-4.0.38-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 741ebc34540a8151749efb75bcf0c4c0f1a962e67e268a4963bee0452af5923d |
|
MD5 | c63374687ac56c0ee38b6187db08bee6 |
|
BLAKE2b-256 | 70a06d331305eb2132141cceca8eefdb1916b0210414cab73dd5aaeab968e651 |
Hashes for pyodbc-4.0.38-cp38-cp38-macosx_11_0_arm64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b9154219785dea409b020336d069fafc67efe5a4c6b61d9ac71b42545792a5ad |
|
MD5 | 703b939612e42054acde83dca3e9a787 |
|
BLAKE2b-256 | 960386bef32b71646f3a14f16f45fb9dccd0c4c90052f049c01f2d6e05ad8418 |
Hashes for pyodbc-4.0.38-cp38-cp38-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5910c8be937611299614a6ead738a886fdcb51091a8d4680a27250f7f9444483 |
|
MD5 | 1fc32f7cd0e3daa93b57be7caaec977c |
|
BLAKE2b-256 | 2b156026918d75b2e02d50f580f641b5d29d7c4a2d585e3a230b22354956cbd0 |
Hashes for pyodbc-4.0.38-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7173011fb424137cede4b2281d984f358e0aff1cbeef764e9847cc4d6bc25995 |
|
MD5 | 1cb45ab0596f029290bd7efc7f6a799d |
|
BLAKE2b-256 | ac5700fd73372f876630349c7b91770a0710772be437d6d451e846ba4f8f8858 |
Hashes for pyodbc-4.0.38-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cf00ec10589cbd5478f77e728dbbd4e7ec158f0741467c14ae5716d1233ebf00 |
|
MD5 | bff3b31c2c6956c7cc5071ac43a89310 |
|
BLAKE2b-256 | 79e4354601b51e5374dd6af236ff046a83273a8a01087e2695416ddb5096aba3 |
Hashes for pyodbc-4.0.38-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c7b9f8ae0248fbdbafe8b15b68422399f03206eb3970d6a574bb7352fae56f71 |
|
MD5 | 90b7e5cf0e35e3030496c2bb37cfaf83 |
|
BLAKE2b-256 | f3ffdc396a4b3ce39d1fa69ce16f277181ef77ddf2d9d048465cb62d7e8e1bf1 |
Hashes for pyodbc-4.0.38-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cb3cd1ed69cfabe26f818aae9eea810978215d414ced61355eccc9363905d061 |
|
MD5 | 57f37600e1616d64f47f47db246cfbe9 |
|
BLAKE2b-256 | ad54d589c6971863d4552225bad7c817470dd0aea70de72d041fdf27cce01d40 |
Hashes for pyodbc-4.0.38-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a075bde092ee69f6aaeacb9ba98eb071e0827b20326d875ad5432f5f90a9de03 |
|
MD5 | 20504b7c52a3959c8643e51f49acf671 |
|
BLAKE2b-256 | cf92d68981816256a63b3470b88516891af73c0b98221c43a449c2a60719deb9 |
Hashes for pyodbc-4.0.38-cp36-cp36m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3d7a7ad4636ca64715548ef383ff0712aca857b86aa4e447a05180e610633a89 |
|
MD5 | ae73809cae7955517af2657e9bbb3101 |
|
BLAKE2b-256 | afe8a424755c819b61540706cd0ff2e8ce12fc9a045a26ebbcf61314a549ecf3 |
Hashes for pyodbc-4.0.38-cp36-cp36m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e5cc5e409fe79322c0503190ef9529837d559930d67fd15d8c33cba20914485c |
|
MD5 | 04ff52c6f17321c7a0925b60454e8725 |
|
BLAKE2b-256 | 4a57589ceefb7a63e1d4fb01a8ee8df1b97d845a9e3fb3cf5dbcd6c3f3b9cc91 |
Hashes for pyodbc-4.0.38-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8c3da1d0658db8bd8bdd9343585bc9dd3a0ea9d9c8e55916f7cd6102de66daca |
|
MD5 | 12d71068b59a3bf11b8cc99545624001 |
|
BLAKE2b-256 | 2723707f4d324c845543b573c3f913461929512941727c47b5278de7e1f8ff96 |
Hashes for pyodbc-4.0.38-cp36-cp36m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 12843a084f21cf6c98f7973d6c57037201ffedec01c8ba4df0792783e15c584e |
|
MD5 | f81b928f3160f4492d5bf4e1f4b0f719 |
|
BLAKE2b-256 | 3ce3b0a8dcdf5755ffbf440e18cc21e1eb6b4cc12d0d648891241f40a32d7c67 |
Hashes for pyodbc-4.0.38-cp36-cp36m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a1190dfa511cfafb078e808c1cb09991862ea752afe2faf3078cfe247298e2da |
|
MD5 | 1fba4c2f48efbc355637891d6973866b |
|
BLAKE2b-256 | 1f637f9c4515932a0948f6640704e78137c783a83cd57884aeed598288d22544 |