DB API module for ODBC

These details have not been verified by PyPI

Project links

Homepage

Development Status
- 5 - Production/Stable
Intended Audience
- Developers
- System Administrators
License
- OSI Approved :: MIT License
Operating System
- Microsoft :: Windows
- POSIX
Programming Language
- Python
- Python :: 3
Topic
- Database

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

Project details

These details have not been verified by PyPI

Project links

Homepage

Development Status
- 5 - Production/Stable
Intended Audience
- Developers
- System Administrators
License
- OSI Approved :: MIT License
Operating System
- Microsoft :: Windows
- POSIX
Programming Language
- Python
- Python :: 3
Topic
- Database

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

This version

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

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-5.0.0b1.tar.gz (95.0 kB view hashes)

Uploaded Aug 27, 2023 Source

Built Distributions

pyodbc-5.0.0b1-cp311-cp311-win_amd64.whl (68.9 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.11 Windows x86-64

pyodbc-5.0.0b1-cp311-cp311-win32.whl (62.1 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.11 Windows x86

pyodbc-5.0.0b1-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (344.5 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.11 manylinux: glibc 2.17+ x86-64

pyodbc-5.0.0b1-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (342.1 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.11 manylinux: glibc 2.17+ ARM64

pyodbc-5.0.0b1-cp311-cp311-macosx_10_9_x86_64.whl (72.3 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.11 macOS 10.9+ x86-64

pyodbc-5.0.0b1-cp310-cp310-win_amd64.whl (68.9 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.10 Windows x86-64

pyodbc-5.0.0b1-cp310-cp310-win32.whl (62.1 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.10 Windows x86

pyodbc-5.0.0b1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (334.3 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.10 manylinux: glibc 2.17+ x86-64

pyodbc-5.0.0b1-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (330.7 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.10 manylinux: glibc 2.17+ ARM64

pyodbc-5.0.0b1-cp310-cp310-macosx_10_9_x86_64.whl (72.2 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.10 macOS 10.9+ x86-64

pyodbc-5.0.0b1-cp39-cp39-win_amd64.whl (68.9 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.9 Windows x86-64

pyodbc-5.0.0b1-cp39-cp39-win32.whl (62.1 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.9 Windows x86

pyodbc-5.0.0b1-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (331.4 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.9 manylinux: glibc 2.17+ x86-64

pyodbc-5.0.0b1-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (328.1 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.9 manylinux: glibc 2.17+ ARM64

pyodbc-5.0.0b1-cp39-cp39-macosx_10_9_x86_64.whl (72.2 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.9 macOS 10.9+ x86-64

pyodbc-5.0.0b1-cp38-cp38-win_amd64.whl (68.8 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.8 Windows x86-64

pyodbc-5.0.0b1-cp38-cp38-win32.whl (62.2 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.8 Windows x86

pyodbc-5.0.0b1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (336.4 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.8 manylinux: glibc 2.17+ x86-64

pyodbc-5.0.0b1-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (332.6 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.8 manylinux: glibc 2.17+ ARM64

pyodbc-5.0.0b1-cp38-cp38-macosx_10_9_x86_64.whl (72.3 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.8 macOS 10.9+ x86-64

pyodbc-5.0.0b1-cp37-cp37m-win_amd64.whl (70.2 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.7m Windows x86-64

pyodbc-5.0.0b1-cp37-cp37m-win32.whl (63.4 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.7m Windows x86

pyodbc-5.0.0b1-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (326.6 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.7m manylinux: glibc 2.17+ x86-64

pyodbc-5.0.0b1-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (326.2 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.7m manylinux: glibc 2.17+ ARM64

pyodbc-5.0.0b1-cp37-cp37m-macosx_10_9_x86_64.whl (72.0 kB view hashes)

Uploaded Aug 27, 2023 CPython 3.7m macOS 10.9+ x86-64

Hashes for pyodbc-5.0.0b1.tar.gz

Hashes for pyodbc-5.0.0b1.tar.gz
Algorithm	Hash digest
SHA256	`14d19d9964cb2a0ac3581807d6616ca811b27203f7351627ef78584584cc4968`
MD5	`e940e7e333b008980d143fbd32203f2c`
BLAKE2b-256	`2e78b7de0d5b893f2187559daf81f1e2e2e9e84f3ecaf78ec5d7c8ebb1cfcc9a`

Hashes for pyodbc-5.0.0b1-cp311-cp311-win_amd64.whl

Hashes for pyodbc-5.0.0b1-cp311-cp311-win_amd64.whl
Algorithm	Hash digest
SHA256	`071ca3ec9554621f7d18c897f4df6599b9db57c82645b2a25012f99228e58971`
MD5	`ef76e926c3077ef9dbc280047679ec7e`
BLAKE2b-256	`d7154d114b5834925feaf3c8550eddd22558becf385ff693b60a58a5f9aec219`

Hashes for pyodbc-5.0.0b1-cp311-cp311-win32.whl

Hashes for pyodbc-5.0.0b1-cp311-cp311-win32.whl
Algorithm	Hash digest
SHA256	`9d2d3e63a1e75e585c0cb4b5554a005c41d420eba96f9743ff38f4b6deacc0de`
MD5	`7d73e9c6fdabe31f0c5a8454eeccaeac`
BLAKE2b-256	`fd3fceea729667dff57660580f55ffa611671057909c855136d672ff7199ea6a`

Hashes for pyodbc-5.0.0b1-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Hashes for pyodbc-5.0.0b1-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm	Hash digest
SHA256	`34bca4af0f604c7ea93b129ba6170e2c82d350cedb1f86bd39ae5a29e14458fa`
MD5	`08f63afa65b7fcfe5ccbffcdfa7ce7a9`
BLAKE2b-256	`f0795a7d49f653080131ce3f45b86a6a0dd450a7113a2154da5e3b66edaf0598`

Hashes for pyodbc-5.0.0b1-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Hashes for pyodbc-5.0.0b1-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm	Hash digest
SHA256	`596cbdc7b36b52c34bb0919fe629baf976d8b1ea268cb8184e47249e99025638`
MD5	`99c711a2ffbfe70aa60b3ddf11a74248`
BLAKE2b-256	`731e114bd1065b5ba83b9ac7f4e5f8f811bc89b9c4c837c7aea49ff1ec9ec2db`

Hashes for pyodbc-5.0.0b1-cp311-cp311-macosx_10_9_x86_64.whl

Hashes for pyodbc-5.0.0b1-cp311-cp311-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`ff5dcf9f6d682abef5f0d1e5b9957235510c9d40fec9ec2ef062dc45a03af142`
MD5	`7e084cbc2c691e05fca4ba5058040af9`
BLAKE2b-256	`dea2d3b095ff49ec2baace8ffd30bfa3e6d1f574ac14aba9005e30ae99f17a74`

Hashes for pyodbc-5.0.0b1-cp310-cp310-win_amd64.whl

Hashes for pyodbc-5.0.0b1-cp310-cp310-win_amd64.whl
Algorithm	Hash digest
SHA256	`b9d7ca78b530e14d608cebefffb243256a64a299bb9c839af23f563e4dc5d4f7`
MD5	`d1984760a43c8e8f6944aface317a7cf`
BLAKE2b-256	`19d02a42827ddab19709b576879286aafdf294389ef23b8651de7a4246e8fbe8`

Hashes for pyodbc-5.0.0b1-cp310-cp310-win32.whl

Hashes for pyodbc-5.0.0b1-cp310-cp310-win32.whl
Algorithm	Hash digest
SHA256	`2107b592c8712af8187fb11c2f90b7e199b19de854484470c9e7f1075e15cb3c`
MD5	`3aa9b545c7db4ec04ee75d4e145add53`
BLAKE2b-256	`45593f86877a0ce429ef8dcd967ff81f6732546509e28b5dcb5dd2a2c453502a`

Hashes for pyodbc-5.0.0b1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Hashes for pyodbc-5.0.0b1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm	Hash digest
SHA256	`f579ea9458fb253abfbacb98886ef193b4afc7933871424a84f4c62cd640e7c5`
MD5	`529dd7e0fc802bdb7654bdb74f414592`
BLAKE2b-256	`b5f4471b616b6408e2fb5054bb799dc4f8369f22b264b18848154b747b47d4f0`

Hashes for pyodbc-5.0.0b1-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Hashes for pyodbc-5.0.0b1-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm	Hash digest
SHA256	`5f836e3b5422ac8bdff1dda57656c26e8e1500f03363e9806ff9dbec82134f88`
MD5	`324bc05c45eff08c8c01798483f38bc1`
BLAKE2b-256	`f0b57d51ad3ae5c136f29c72dde7e0af711ceae9ddff04133eb9030df1a949a9`

Hashes for pyodbc-5.0.0b1-cp310-cp310-macosx_10_9_x86_64.whl

Hashes for pyodbc-5.0.0b1-cp310-cp310-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`dddd7e9a30758ea5e3621da897e463777142377850c8a9851dfa1e81ad586ed6`
MD5	`18562a58d5b28e16126b2fa3caa93435`
BLAKE2b-256	`24e4f3b5364d8d3c00d05d3537455018d959a940ead3510a77ab7b831b58f5d6`

Hashes for pyodbc-5.0.0b1-cp39-cp39-win_amd64.whl

Hashes for pyodbc-5.0.0b1-cp39-cp39-win_amd64.whl
Algorithm	Hash digest
SHA256	`a4dd7293c89bb729ece9a1e30d877f3d385315b4a2a8e8a2727fd374a16285db`
MD5	`612a283332367552891c24f1f081224d`
BLAKE2b-256	`210df6f9fcbf74b84a6ec789cd283b4aebf1bfcc7c886bde656576204220ebe0`

Hashes for pyodbc-5.0.0b1-cp39-cp39-win32.whl

Hashes for pyodbc-5.0.0b1-cp39-cp39-win32.whl
Algorithm	Hash digest
SHA256	`f699dfd72e5a8db00c04f8e6ee8ec4fbf7ba1eca793b63410b6a7f7d154cc3fe`
MD5	`53396522f0cf5508e0bdb3fef61a5fe3`
BLAKE2b-256	`dca76aa378da0dac9b889a8fcd02e0cb586d061db7f2694630156032a84da447`

Hashes for pyodbc-5.0.0b1-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Hashes for pyodbc-5.0.0b1-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm	Hash digest
SHA256	`bdb44686643648083388b2d846d7398f4bd25ae6b164f903c1686815a0a24cf1`
MD5	`cf02326f3c726b987a9a8a1ea20f5941`
BLAKE2b-256	`540b78e499b45d67d12a0b49d9696e9b99b0287c1dd72b6c6830779ee484dcb0`

Hashes for pyodbc-5.0.0b1-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Hashes for pyodbc-5.0.0b1-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm	Hash digest
SHA256	`04a7c80d25eaeaecd95a2d2383346b7532cb77d03628b70ee3ff141bbe9a4382`
MD5	`9298806f46bd5bc3711bec509250fd37`
BLAKE2b-256	`d963603e378d9781a9baca606c04f9a85d2bb42be168ae24752736d200bea580`

Hashes for pyodbc-5.0.0b1-cp39-cp39-macosx_10_9_x86_64.whl

Hashes for pyodbc-5.0.0b1-cp39-cp39-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`578b57c53e97a2caaa8384f43e0d614f1c21626ee1ab1477bc785094d293a24c`
MD5	`fdedef273b78990dfd1a748524c1ccc4`
BLAKE2b-256	`1bee4f5f31bc1c6dda060460fa4c8eae5264baae3cc26a114196f4ddd0c710b5`

Hashes for pyodbc-5.0.0b1-cp38-cp38-win_amd64.whl

Hashes for pyodbc-5.0.0b1-cp38-cp38-win_amd64.whl
Algorithm	Hash digest
SHA256	`c3085c569824c340eaa3f41f390026a1dd9c22434d7cb2be84a9b2b27e0bf95c`
MD5	`b099cd9e8634c6a55752e188b23b3310`
BLAKE2b-256	`bab884b65abe5b3547e057ae724b28d0d7d74dc67d8b9a613c51da443e2bafa0`

Hashes for pyodbc-5.0.0b1-cp38-cp38-win32.whl

Hashes for pyodbc-5.0.0b1-cp38-cp38-win32.whl
Algorithm	Hash digest
SHA256	`c7474281386b3ed7bf202c409b6b86bbf0b711a02f1bbf3d04179ef9994dcca7`
MD5	`87e79760c7ac557cb019279ec4b02bfc`
BLAKE2b-256	`19326277b89c84ee7254a3b95d0a6c577565c119ae2aabc310ed19ef67018467`

Hashes for pyodbc-5.0.0b1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Hashes for pyodbc-5.0.0b1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm	Hash digest
SHA256	`9c92e04381734eb083a9853ba95afe8c761800679b925d7d08fd6a5773c15d7e`
MD5	`b32c8fb6c5c15391068683039cc7e8c0`
BLAKE2b-256	`a99e46dbd30a546d2b5649a4c1a876c15adc0ca66fe17bd4d0f1f1b9fb359629`

Hashes for pyodbc-5.0.0b1-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Hashes for pyodbc-5.0.0b1-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm	Hash digest
SHA256	`e0c83c66343bf2a500f60a936d59174197645eacbfc023442f9a5c06ac3388d5`
MD5	`fb254bf7c8bc28e82bf8adf2a882972c`
BLAKE2b-256	`704d70b1221d6cd63e0232c16baea18b493b0485f7b0f4cd0a0a4cd223d3360b`

Hashes for pyodbc-5.0.0b1-cp38-cp38-macosx_10_9_x86_64.whl

Hashes for pyodbc-5.0.0b1-cp38-cp38-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`01dde106beb96ea1ba8caf02beae0b3085f08b8bab83f805c6baf0cbd2752a42`
MD5	`b3860ef93c96180d885be9bcc1a3d507`
BLAKE2b-256	`673de2d464a6702c33ccec0f7988f41442e602c8c62ab2752a40ecf6813d21ea`

Hashes for pyodbc-5.0.0b1-cp37-cp37m-win_amd64.whl

Hashes for pyodbc-5.0.0b1-cp37-cp37m-win_amd64.whl
Algorithm	Hash digest
SHA256	`21d0d5bdb8cf2a9f580515ce852d3c54252f3aab8b3de43f2434502f428f8b1d`
MD5	`07b07ee25c4ac8462ce3fdd17f389583`
BLAKE2b-256	`64e981a9e14da65951bb96c4a496ee3a81517187feeef0992447e7d28ce0f56d`

Hashes for pyodbc-5.0.0b1-cp37-cp37m-win32.whl

Hashes for pyodbc-5.0.0b1-cp37-cp37m-win32.whl
Algorithm	Hash digest
SHA256	`a096a264796b30015c6c84a785564d4a006b6d5d735aac210a361d288faf1fc8`
MD5	`a739d3a6be8578a7a2c34731d3c029ae`
BLAKE2b-256	`02eb206acd7aa0c43c4b71d8d7a5391a8f61c2615f4e7384f165fd64c96feb88`

Hashes for pyodbc-5.0.0b1-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Hashes for pyodbc-5.0.0b1-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm	Hash digest
SHA256	`f0537bcb1e3c57d0e509af4e823ae75af1fb8a1ed215cef79d8b4a0f6cd69676`
MD5	`cfdec8e3f1cf5cfd5c75280f08c22d97`
BLAKE2b-256	`02376b4820ed7e2fb43aacd138e35e6b1fe948b4dd8f6585b31ca3c0d4367b40`

Hashes for pyodbc-5.0.0b1-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Hashes for pyodbc-5.0.0b1-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm	Hash digest
SHA256	`7252a8ea54e183139b2d4653674d944e92a001f3aec1ce0b1be8a2a6fd468cbf`
MD5	`758302edd993eed1a70bcbe6f43811a5`
BLAKE2b-256	`5cfb40e295626e9fb8240af6a87c70ce688423bcd5f862eeb10496d95690f322`

Hashes for pyodbc-5.0.0b1-cp37-cp37m-macosx_10_9_x86_64.whl

Hashes for pyodbc-5.0.0b1-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`c5fea3a8edcc9f6c782bb8ed7bc170a5c7727d0805ecd2bb3e2d1f056649dbb6`
MD5	`026c9432ab2298736259521597fb6337`
BLAKE2b-256	`d40cb012066a8dbc2df6d08618ba8c365f721e9c1629e5f226d198b57f3a1aa4`