Skip to main content

Python interface to ODBC

Project description

Open Source Python/ODBC Utility - ceODBC

ceODBC is a Python extension module that enables access to databases using the ODBC API and conforms to the Python database API 2.0 specifications with a number of additions. Python 3.6 and higher is required as of version 3.0.

See https://www.python.org/dev/peps/pep-0249 for more information on the Python database API specification.

For feedback or patches, please use GitHub issues: https://github.com/anthony-tuininga/ceODBC/issues

Installation

python -m pip install ceODBC --upgrade

Add the --user option if you do not have system access. Binaries are available for Linux and Windows as a convenience.

Usage Example

Note that the DSN in the example below should be replaced with an appropriate string that ODBC understands. For example, if a system DSN called "MYDATA" has been created in the ODBC manager, use "DSN=MYDATA" to connect. For what is termed DSN-less connections, search the Internet for appropriate strings.

import ceODBC

connection = ceODBC.connect(DSN)

cursor = connection.cursor()
cursor.execute("""
        select Col1, Col2, Col3
        from SomeTable
        where Col4 = ?
          and Col5 between ? and ?""",
        ["VALUE", 5, 10])
for column_1, column_2, column_3 in cursor:
    print("Values:", column_1, column_2, column_3)

Notes

If your driver is not capable of transactions (often indicated by the exception "driver not capable" when connecting) then use the following statement to connect instead:

connection = ceODBC.connect(DSN, autocommit=True)

For further information see

http://ceodbc.readthedocs.org

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for ceODBC, version 3.0
Filename, size File type Python version Upload date Hashes
Filename, size ceODBC-3.0-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (737.5 kB) File type Wheel Python version cp36 Upload date Hashes View
Filename, size ceODBC-3.0-cp36-cp36m-win32.whl (88.5 kB) File type Wheel Python version cp36 Upload date Hashes View
Filename, size ceODBC-3.0-cp36-cp36m-win_amd64.whl (106.1 kB) File type Wheel Python version cp36 Upload date Hashes View
Filename, size ceODBC-3.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (734.2 kB) File type Wheel Python version cp37 Upload date Hashes View
Filename, size ceODBC-3.0-cp37-cp37m-win32.whl (79.2 kB) File type Wheel Python version cp37 Upload date Hashes View
Filename, size ceODBC-3.0-cp37-cp37m-win_amd64.whl (94.1 kB) File type Wheel Python version cp37 Upload date Hashes View
Filename, size ceODBC-3.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (837.6 kB) File type Wheel Python version cp38 Upload date Hashes View
Filename, size ceODBC-3.0-cp38-cp38-win32.whl (81.2 kB) File type Wheel Python version cp38 Upload date Hashes View
Filename, size ceODBC-3.0-cp38-cp38-win_amd64.whl (96.8 kB) File type Wheel Python version cp38 Upload date Hashes View
Filename, size ceODBC-3.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (790.5 kB) File type Wheel Python version cp39 Upload date Hashes View
Filename, size ceODBC-3.0-cp39-cp39-win32.whl (80.8 kB) File type Wheel Python version cp39 Upload date Hashes View
Filename, size ceODBC-3.0-cp39-cp39-win_amd64.whl (96.1 kB) File type Wheel Python version cp39 Upload date Hashes View
Filename, size ceODBC-3.0.tar.gz (161.8 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page