pyodbc 5.1.0

DB API module for ODBC

Stars: 2860, Watchers: 2860, Forks: 556, Open Issues: 55

The mkleehammer/pyodbc repo was created 15 years ago and the last code push was 14 hours ago.
The project is very popular with an impressive 2860 github stars!

How to Install pyodbc

You can install pyodbc using pip

pip install pyodbc

or add it to a project with poetry

poetry add pyodbc

Package Details

Author

License

MIT License

Homepage

https://github.com/mkleehammer/pyodbc

PyPi:

https://pypi.org/project/pyodbc/

GitHub Repo:

https://github.com/mkleehammer/pyodbc

Classifiers

• Database

Related Packages

Errors

A list of common pyodbc errors.

Code Examples

Here are some pyodbc code examples and snippets.

GitHub Issues

The pyodbc package has 55 open issues on GitHub

• Caching query results
• Connection using Tibco driver fetches only first row and segfaults on subsequent ones
• InterfaceError missing from pyodbc.pyi
• 'pyodbc.Error' returned a result with an error set
• Added InterfaceError to pyodbc.pyi.
• Fedora 35 / Python 3.10.1 / mysql 8 / Can't open lib '/usr/lib64/unixODBC/libmyodbc8.so'
• Windows 11. Python 3.10.1 Impossible to install pyodbc
• Unable to connect to SQL Server using email address
• Unable to pass limit as parameter for oracledb
• Adjust test_columns() in tests3/pgtests.py for newer driver versions
• Disable setencoding/setdecoding in tests3/pgtests.py
• pgtests test_emoticons_as_literal fails
• PostgreSQL unit test tries to access non-existent 'precision' attribute
• Replace deprecated PyUnicode_FromUnicode(NULL, size) calls (#998)
• Avoid error when testing with DSN= connection

See more issues on GitHub