pyodbc

The simplest way to install pyodbc is using pip. Precompiled binary wheels are available for most Windows, macOS, and Linux platforms.

python -m pip install pyodbc

For fast development turnaround without using tox, you can build the library in-place and run pytest manually. Building with the --inplace flag ensures the library is built into the root directory, making it available in the path for your tests.

To build the extension in-place:

python setup.py build_ext --inplace

To run a specific test (e.g., test_text in test_postgresql.py):

pytest test/test_postgresql.py -vxk test_text

Before installing pyodbc on macOS, you must ensure an ODBC driver manager is installed. It is recommended to use unixODBC via Homebrew.

brew install unixodbc
python -m pip install pyodbc

On Windows, the ODBC driver manager is built-in, so you can install pyodbc directly using pip.

python -m pip install pyodbc

If a segmentation fault occurs during testing, pytest may suppress the output. To see the output and debug the crash, enable PYODBC_TRACE during the build and add the -s flag to your pytest command to prevent output buffering.

Use the following commands to debug:

python setup.py build_ext --inplace -D PYODBC_TRACE
pytest test/test_postgresql.py -vxk test_text -vs