pyodbc

DB API module for ODBC

MIT 64 个版本 Python >=3.9

安装

pip install pyodbc

poetry add pyodbc

pipenv install pyodbc

conda install pyodbc

描述

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:

python -m pip install pyodbc

On Macs, you should probably install unixODBC first if you don't already have an ODBC driver manager installed. For example, using the homebrew package manager:

brew install unixodbc
python -m 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 you will need a suitable C++ compiler when building from source. See the docs for details.

Documentation

Release Notes

分类

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

版本列表

5.3.0 2025-10-17

5.2.0 2024-10-16

5.1.0 2024-02-05

5.0.1 2023-10-13

5.0.0 2023-10-10

5.0.0b3 2023-08-29

5.0.0b2 2023-08-28

5.0.0b1 2023-08-27

5.0.0a2 2023-08-26

4.0.39 2023-04-14

4.0.38 2023-04-11

4.0.35 2022-11-16

4.0.34 2022-07-14

4.0.32 2021-08-19

4.0.31 2021-07-04

4.0.30 2020-02-08

4.0.28 2019-12-26

4.0.27 2019-07-31

4.0.26 2019-02-23

4.0.25 2018-12-14

4.0.24 2018-08-15

4.0.23 2018-03-30

4.0.22 2018-01-19

4.0.21 2017-10-31

4.0.20 2017-10-31

4.0.19 2017-10-23

4.0.18 2017-10-20

4.0.17 2017-06-21

4.0.16 2017-03-30

4.0.15 2017-03-15

4.0.14 2017-03-05

4.0.13 2017-02-25

4.0.12 2017-02-25

4.0.11 2017-02-19

4.0.10 2017-02-19

4.0.9 2017-02-19

4.0.8 2017-02-17

4.0.7 2017-02-16

4.0.6 2017-02-13

4.0.5 2017-02-11

4.0.3 2017-01-20

4.0.2 2017-01-19

4.0.1 2017-01-13

4.0.0 2016-12-30

4.0.30b1 2020-02-10

3.1.1 2016-11-29

3.0.10 2015-04-29

3.0.9 2015-04-28

3.0.8 2015-04-25

3.0.7 2015-09-24

3.0.6 2015-09-24

3.0.3 2015-09-24

3.0.2

2.1.11 2015-09-24

2.1.10 2015-09-24

2.1.9 2015-09-24

2.1.8 2015-09-24

2.1.7 2015-09-24

2.1.6 2015-09-24

2.1.5 2015-09-24

2.1.4 2015-09-24

2.1.3 2015-09-24

2.1.2 2015-09-24

2.1.1 2015-09-24