Install

Overview

Typically, pyodbc is installed like any other Python package by running:

pip install pyodbc

from a Windows DOS prompt or Unix shell. See the pip documentation for more details about the pip utility. However you may find you get this error:

$ pip install pyodbc
Downloading/unpacking pyodbc
  Could not find any downloads that satisfy the requirement pyodbc
  Some externally hosted files were ignored (use --allow-external pyodbc to allow).
Cleaning up...
No distributions at all found for pyodbc
$

In which case, try:

pip install pyodbc --allow-unverified pyodbc

You will get some warning messages, but it should work.

It is recommended that you consider using Python virtual environments before installing pyodbc.

Windows

Alternatively, pyodbc can be installed by downloading 'wheels' from Christoph Gohlke's excellent collection of Windows binaries, located here.

To install a wheel, simply download the appropriate one to your PC and run:

pip install C:\Path\To\Your\Downloaded\WheelFile.whl

For example, to install the 64-bit version of pyodbc for Python 2.7, run:

pip install pyopencl‑2015.1‑cp27‑none‑win_amd64.whl