Install - mkleehammer/pyodbc GitHub Wiki

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

pip install pyodbc

from a Windows DOS prompt or Unix shell, but don't forget the pre-requisites described below. See the pip documentation for more details about the pip utility. As always when installing modules, you should consider using Python virtual environments.

However, if you want to install pyodbc directly from a binary wheel, you can download them from the Python Package Index (PyPi) and install with pip install your-wheel-file.whl. Wheels for older versions of pyodbc can also be found there.

Try pip install pyodbc first. This should "just work" in the vast majority of cases. pip will download the correct pyodbc wheel for your PC/Python set up and install it.

If for some reason you need to build pyodbc from source — e.g., if pip install pyodbc downloads a source distribution like "pyodbc-4.0.35.tar.gz" instead of a pre-built wheel (.whl) file — then make sure you have the appropriate C++ compiler on your PC. Look here for details on that.

Binary wheels for MacOSX are published for most Python versions and for both Intel and ARM processors (pyodbc v5.1.0 onwards). However, before installing pyodbc make sure you have already installed a driver manager. pyodbc does not provide a driver manager. The recommended driver manager on Macs is unixODBC so typically, pyodbc on MacOSX would be installed as follows:

brew install unixodbc
pip install pyodbc

In a conda environment, use conda install unixodbc instead of brew install unixodbc.

To install pre-v5.1.0 pyodbc on ARM64 Macs, try compiling from the source distribution:

brew install unixodbc
pip install --no-binary=pyodbc pyodbc

Starting with pyodbc 4.0.35, Linux wheels are available from PyPI. However, they do not include their own copies of the unixODBC library files (because that caused problems), so if pip installs pyodbc from those wheel files then unixODBC must be installed separately.

That is, if you pip install pyodbc and receive this error when you try to import pyodbc

$ python
Python 3.10.6 (main, Nov  2 2022, 18:53:38) [GCC 11.3.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import pyodbc
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: libodbc.so.2: cannot open shared object file: No such file or directory

then install unixODBC. For example, on Ubuntu that would be

$ sudo apt install unixodbc

The following are the older instructions for previous versions of pyodbc where it was installed from the source distribution (sdist). They may be helpful if you are using a distribution that is not compatible with the 4.0.35+ wheels (e.g., Oracle Linux 8.5).

apk add python3 python3-dev g++ unixodbc-dev
python3 -m ensurepip
pip3 install --user pyodbc

Amazon Linux 2 is similar to Red Hat and CentOS

sudo yum install gcc-c++ python3-devel unixODBC-devel
# replace <release_num> with the current release
sudo ln -s /usr/libexec/gcc/x86_64-amazon-linux/<release_num>/cc1plus /usr/bin/
pip3 install --user pyodbc

https://docs.microsoft.com/en-us/azure/databricks/kb/libraries/install-pyodbc-on-cluster

From a clean minimal install of CentOS 7, the following steps were required:

sudo yum install epel-release
sudo yum install python-pip gcc-c++ python-devel unixODBC-devel
pip install --user pyodbc

sudo yum install epel-release
sudo yum install python3-pip gcc-c++ python3-devel unixODBC-devel
pip3 install --user pyodbc

Similar to Ubuntu, you need to install unixodbc-dev, but you will also need to install gcc and g++. Note gcc package is automatically installed when installing g++

apt-get update
apt-get install g++ unixodbc-dev
pip install --user pyodbc

sudo dnf install redhat-rpm-config gcc-c++ python3-devel unixODBC-devel
pip3 install --user pyodbc

Similar to Fedora, the following packages were required after a clean install of OpenSUSE Leap 42.3

sudo zypper install gcc-c++ python3-devel python3-pip unixODBC-devel
pip3 install --user pyodbc

The following packages were required after a clean install of Oracle Linux 8.5

sudo dnf install gcc-c++ python3-devel unixODBC-devel
pip3 install --user pyodbc