Coding With Fun
Home Docker Django Node.js Articles Python pip guide FAQ Policy
 

How to install pyodbc via python pip

pyodbc - DB API Module for ODBC, it belongs to Classifiers:

- Intended Audience :: System Administrators
- Operating System :: Microsoft
- Operating System :: Microsoft :: Windows
- Topic :: Database

When you know about this project and you want to new install pyodbc to support your project or you get trouble as ModuleNotFoundError: No module named "pyodbc" or ImportError: cannot import name "pyodbc" in your project, let follow this tutorial to install pyodbc

Installation:

Step 1: First, ensure you installed pip in your os, to check pip has been installed on your computer

In Windows (CMD):

py -m pip --version

In Unix/macOS:

python3 -m pip --version

Ensure pip, setuptools, and wheel are up to date:

In Windows (CMD):

py -m pip install --upgrade pip setuptools wheel

In Unix/macOS:

python3 -m pip install --upgrade pip setuptools wheel

Optional - If you want to install in virtual environment:

In Windows (CMD):

- Install virtualenv - if you installed it, please ignore

py -m pip install --user virtualenv

- Create a virtual environment

py -m venv test_pyodbc_env

- Active the virtual environment

test_pyodbc_env\Scripts\active

In Unix/macOS:

- Install virtualenv - if you installed it, please ignore

pip3 install virtualenv

- Create a virtual environment

python3 -m venv test_pyodbc_env

- Active the virtual environment

source test_pyodbc_env/bin/active

Step 2: OK, now, let flow below content to start the installation pyodbc

To install pyodbc on Windows(CMD):

py -m pip install pyodbc

To install pyodbc on Unix/macOs:

pip install pyodbc

Step 3: If you want to install a specific pyodbc version, add ==<pyodbc version> to the end command line

Example: 

pip install pyodbc==2.1.1

Please see the version list below table:

VersionReleased dateCommand
pyodbc 4.0.342022-07-14T20:40:25Windows:

py -m pip install pyodbc==4.0.34

Unix/macOs:

pip install pyodbc==4.0.34

pyodbc 4.0.322021-08-19T20:25:00Windows:

py -m pip install pyodbc==4.0.32

Unix/macOs:

pip install pyodbc==4.0.32

pyodbc 4.0.312021-07-04T01:11:33Windows:

py -m pip install pyodbc==4.0.31

Unix/macOs:

pip install pyodbc==4.0.31

pyodbc 4.0.302020-02-08T17:52:28Windows:

py -m pip install pyodbc==4.0.30

Unix/macOs:

pip install pyodbc==4.0.30

pyodbc 4.0.282019-12-21T18:28:48Windows:

py -m pip install pyodbc==4.0.28

Unix/macOs:

pip install pyodbc==4.0.28

pyodbc 4.0.272019-07-31T03:17:43Windows:

py -m pip install pyodbc==4.0.27

Unix/macOs:

pip install pyodbc==4.0.27

pyodbc 4.0.262019-02-23T19:18:34Windows:

py -m pip install pyodbc==4.0.26

Unix/macOs:

pip install pyodbc==4.0.26

pyodbc 4.0.252018-12-14T03:05:00Windows:

py -m pip install pyodbc==4.0.25

Unix/macOs:

pip install pyodbc==4.0.25

pyodbc 4.0.242018-08-15T16:35:41Windows:

py -m pip install pyodbc==4.0.24

Unix/macOs:

pip install pyodbc==4.0.24

pyodbc 4.0.232018-03-30T15:23:10Windows:

py -m pip install pyodbc==4.0.23

Unix/macOs:

pip install pyodbc==4.0.23

pyodbc 4.0.222018-01-19T02:53:04Windows:

py -m pip install pyodbc==4.0.22

Unix/macOs:

pip install pyodbc==4.0.22

pyodbc 4.0.212017-10-31T21:41:40Windows:

py -m pip install pyodbc==4.0.21

Unix/macOs:

pip install pyodbc==4.0.21

pyodbc 4.0.202017-10-31T21:31:29Windows:

py -m pip install pyodbc==4.0.20

Unix/macOs:

pip install pyodbc==4.0.20

pyodbc 4.0.192017-10-23T13:23:13Windows:

py -m pip install pyodbc==4.0.19

Unix/macOs:

pip install pyodbc==4.0.19

pyodbc 4.0.182017-10-20T19:44:39Windows:

py -m pip install pyodbc==4.0.18

Unix/macOs:

pip install pyodbc==4.0.18

pyodbc 4.0.172017-06-21T17:28:20Windows:

py -m pip install pyodbc==4.0.17

Unix/macOs:

pip install pyodbc==4.0.17

pyodbc 4.0.162017-03-30T16:57:56Windows:

py -m pip install pyodbc==4.0.16

Unix/macOs:

pip install pyodbc==4.0.16

pyodbc 4.0.152017-03-15T21:12:24Windows:

py -m pip install pyodbc==4.0.15

Unix/macOs:

pip install pyodbc==4.0.15

pyodbc 4.0.142017-03-04T20:16:55Windows:

py -m pip install pyodbc==4.0.14

Unix/macOs:

pip install pyodbc==4.0.14

pyodbc 4.0.132017-02-25T22:38:57Windows:

py -m pip install pyodbc==4.0.13

Unix/macOs:

pip install pyodbc==4.0.13

pyodbc 4.0.122017-02-25T19:22:20Windows:

py -m pip install pyodbc==4.0.12

Unix/macOs:

pip install pyodbc==4.0.12

pyodbc 4.0.112017-02-19T22:32:28Windows:

py -m pip install pyodbc==4.0.11

Unix/macOs:

pip install pyodbc==4.0.11

pyodbc 4.0.102017-02-19T22:20:54Windows:

py -m pip install pyodbc==4.0.10

Unix/macOs:

pip install pyodbc==4.0.10

pyodbc 4.0.92017-02-19T00:05:13Windows:

py -m pip install pyodbc==4.0.9

Unix/macOs:

pip install pyodbc==4.0.9

pyodbc 4.0.82017-02-17T23:34:33Windows:

py -m pip install pyodbc==4.0.8

Unix/macOs:

pip install pyodbc==4.0.8

pyodbc 4.0.72017-02-16T21:58:16Windows:

py -m pip install pyodbc==4.0.7

Unix/macOs:

pip install pyodbc==4.0.7

pyodbc 4.0.62017-02-13T17:11:45Windows:

py -m pip install pyodbc==4.0.6

Unix/macOs:

pip install pyodbc==4.0.6

pyodbc 4.0.52017-02-11T03:39:06Windows:

py -m pip install pyodbc==4.0.5

Unix/macOs:

pip install pyodbc==4.0.5

pyodbc 4.0.32017-01-20T19:20:08Windows:

py -m pip install pyodbc==4.0.3

Unix/macOs:

pip install pyodbc==4.0.3

pyodbc 4.0.22017-01-19T20:19:20Windows:

py -m pip install pyodbc==4.0.2

Unix/macOs:

pip install pyodbc==4.0.2

pyodbc 4.0.12017-01-13T19:29:56Windows:

py -m pip install pyodbc==4.0.1

Unix/macOs:

pip install pyodbc==4.0.1

pyodbc 4.0.02016-12-30T16:17:59Windows:

py -m pip install pyodbc==4.0.0

Unix/macOs:

pip install pyodbc==4.0.0

pyodbc 3.1.12016-11-29T01:44:21Windows:

py -m pip install pyodbc==3.1.1

Unix/macOs:

pip install pyodbc==3.1.1

pyodbc 3.0.102015-04-29T21:48:34Windows:

py -m pip install pyodbc==3.0.10

Unix/macOs:

pip install pyodbc==3.0.10

pyodbc 3.0.92015-04-28T02:17:32Windows:

py -m pip install pyodbc==3.0.9

Unix/macOs:

pip install pyodbc==3.0.9

pyodbc 3.0.82015-04-25T03:30:06Windows:

py -m pip install pyodbc==3.0.8

Unix/macOs:

pip install pyodbc==3.0.8

pyodbc 3.0.72013-07-14T16:03:56Windows:

py -m pip install pyodbc==3.0.7

Unix/macOs:

pip install pyodbc==3.0.7

pyodbc 3.0.62012-06-24T22:58:38Windows:

py -m pip install pyodbc==3.0.6

Unix/macOs:

pip install pyodbc==3.0.6

pyodbc 3.0.32012-01-04T00:01:45Windows:

py -m pip install pyodbc==3.0.3

Unix/macOs:

pip install pyodbc==3.0.3

pyodbc 3.0.22011-12-27T02:27:06Windows:

py -m pip install pyodbc==3.0.2

Unix/macOs:

pip install pyodbc==3.0.2

pyodbc 2.1.112011-09-14T00:05:53Windows:

py -m pip install pyodbc==2.1.11

Unix/macOs:

pip install pyodbc==2.1.11

pyodbc 2.1.102011-09-13T01:42:48Windows:

py -m pip install pyodbc==2.1.10

Unix/macOs:

pip install pyodbc==2.1.10

pyodbc 2.1.92015-09-24T19:50:56Windows:

py -m pip install pyodbc==2.1.9

Unix/macOs:

pip install pyodbc==2.1.9

pyodbc 2.1.82010-09-06T18:22:20Windows:

py -m pip install pyodbc==2.1.8

Unix/macOs:

pip install pyodbc==2.1.8

pyodbc 2.1.72010-02-19T21:03:02Windows:

py -m pip install pyodbc==2.1.7

Unix/macOs:

pip install pyodbc==2.1.7

pyodbc 2.1.62009-05-24T23:10:52Windows:

py -m pip install pyodbc==2.1.6

Unix/macOs:

pip install pyodbc==2.1.6

pyodbc 2.1.52015-09-24T19:50:38Windows:

py -m pip install pyodbc==2.1.5

Unix/macOs:

pip install pyodbc==2.1.5

pyodbc 2.1.42015-09-24T19:50:32Windows:

py -m pip install pyodbc==2.1.4

Unix/macOs:

pip install pyodbc==2.1.4

pyodbc 2.1.32008-12-31T06:03:34Windows:

py -m pip install pyodbc==2.1.3

Unix/macOs:

pip install pyodbc==2.1.3

pyodbc 2.1.22015-09-24T19:50:21Windows:

py -m pip install pyodbc==2.1.2

Unix/macOs:

pip install pyodbc==2.1.2

pyodbc 2.1.12008-11-26T21:24:27Windows:

py -m pip install pyodbc==2.1.1

Unix/macOs:

pip install pyodbc==2.1.1

Step 4: Otherwise, you can install pyodbc from local archives:

Download the distribution file from pyodbc-4.0.34.tar.gz or the specific pyodbc version in the below list of distribution

After that, install by command:

On Windows(CMD):

py -m pip install <path_to_pyodbc_downloaded_file>

On Unix/macOs:

pip install <path_to_pyodbc_downloaded_file>

List distribution:

Project link:

- Homepage

 

Related

pyocient

pyocker

pyocr

pyocs

pyoctave

pyoctopart

pyoctree

pyoculus

pyod

pyodata

pyodbc

Pyodbc-Knight

pyodbc-raw

pyodbc-unittest

pyodbcOpenEdge

PyODBCSQLServer2000Database

pyodc

PyODE

pyodesys

pyodhean