pyodbc 5.1.0

DB API module for ODBC

Stars: 2927, Watchers: 2927, Forks: 561, Open Issues: 47

The mkleehammer/pyodbc repo was created 16 years ago and the last code push was 2 days ago.
The project is very popular with an impressive 2927 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 47 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