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.7 and higher is required as of version 3.1.
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
1 maintainer
Release files for ceODBC 3.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| ceODBC-3.1.tar.gz | 171.4 kB | Details |
Built distributions (wheels)
Total release size: 24.3 MB
Release files / ceODBC-3.1.tar.gz
| Download URL | ceODBC-3.1.tar.gz |
|---|---|
| Size | 171.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
3099e978071b1fd234cac5d4ad8253646ca4aefa314f7332687ba4847a259a19
|
|
BLAKE2b-256 checksum How to use checksums |
bea7c4bd12fee195f577e81bed01f1de95fc204a360f8bfb2163ca74a7ae1697
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp311-cp311-win_amd64.whl
| Download URL | ceODBC-3.1-cp311-cp311-win_amd64.whl |
|---|---|
| Size | 782.4 kB |
| Tags | CPython 3.11 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
d8c6e39604920afc37a6173aa7323e1da28d5f29917318500020e278f8498f21
|
|
BLAKE2b-256 checksum How to use checksums |
8142b4a7a71656f434ad28c37d8cc858056049dbf97377ed23227403f093bed0
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp311-cp311-win32.whl
| Download URL | ceODBC-3.1-cp311-cp311-win32.whl |
|---|---|
| Size | 700.6 kB |
| Tags | CPython 3.11 Windows x86-32 |
|
SHA-256 checksum How to use checksums |
4916775a9fb4c93ef908b4eb453bb59a6f4898b9339db29cc24b7c48c89dfaf2
|
|
BLAKE2b-256 checksum How to use checksums |
5c773d2e6c6cd0727e21dd313b5f8af16851637731831eaefa88d7d268cc46f4
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
| Download URL | ceODBC-3.1-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl |
|---|---|
| Size | 3.2 MB |
| Tags | CPython 3.11 Linux glibc 2.17+ x86-64 |
|
SHA-256 checksum How to use checksums |
86236b6f92b8e54340d8ce55db76ef956d7403a3e4cf95330a32a8365dc55981
|
|
BLAKE2b-256 checksum How to use checksums |
90dd2e2416492e24afd558bbe91977756db1f53cf92cdbf2d8e3915adc312c81
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
| Download URL | ceODBC-3.1-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl |
|---|---|
| Size | 3.2 MB |
| Tags | CPython 3.11 Linux glibc 2.17+ ARM64 |
|
SHA-256 checksum How to use checksums |
e1542f68beb5b60d0e3df41eec9fc22b85a6107c72e63eeb82cbf74f320734b4
|
|
BLAKE2b-256 checksum How to use checksums |
9e003221911baf90a0171c6b26796abc6e78e40b4f3897ea10ab555c48dd59bf
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp310-cp310-win_amd64.whl
| Download URL | ceODBC-3.1-cp310-cp310-win_amd64.whl |
|---|---|
| Size | 630.7 kB |
| Tags | CPython 3.10 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
e5a7a9b198203e875669233036e1e53cc90d258dd65dbecf61ca240220a9a2e1
|
|
BLAKE2b-256 checksum How to use checksums |
8f5e9338c532bb6eb5ebd237c1a7bf63585f78765ec40e441cf33f81bd47ba2b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp310-cp310-win32.whl
| Download URL | ceODBC-3.1-cp310-cp310-win32.whl |
|---|---|
| Size | 548.6 kB |
| Tags | CPython 3.10 Windows x86-32 |
|
SHA-256 checksum How to use checksums |
6b1ef7ab199be5c8582418244f8be80bfc23f73e892274a64cf210412f679b85
|
|
BLAKE2b-256 checksum How to use checksums |
5c3dd0093939ab674503b6874e269be07620e823bad57bd219ff3deeca87545a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
| Download URL | ceODBC-3.1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl |
|---|---|
| Size | 2.6 MB |
| Tags | CPython 3.10 Linux glibc 2.17+ x86-64 |
|
SHA-256 checksum How to use checksums |
cf80849a3daf33b91c56676aff6fbada77def493e57852a15e12d4d02e7c2995
|
|
BLAKE2b-256 checksum How to use checksums |
115276afbb1bba46cd42e4f87a31efaba06abc1c6cb4b8d890ce28bea98c2455
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
| Download URL | ceODBC-3.1-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl |
|---|---|
| Size | 2.6 MB |
| Tags | CPython 3.10 Linux glibc 2.17+ ARM64 |
|
SHA-256 checksum How to use checksums |
c3799bfaa29f368816e36483b343a180431b73a5affb3519f2b98118b3fb895b
|
|
BLAKE2b-256 checksum How to use checksums |
2de0c7a457fb20edf42e212669cce4daacdd6fe3f96c4c87b6de9ddd7818ed8b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp39-cp39-win_amd64.whl
| Download URL | ceODBC-3.1-cp39-cp39-win_amd64.whl |
|---|---|
| Size | 478.3 kB |
| Tags | CPython 3.9 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
db10ac27b960e4db277479d76979ec754a777876ebbee39d6dd1e03feac21b8f
|
|
BLAKE2b-256 checksum How to use checksums |
75df4782ba55dee316a86d0adf5c5051e0e17679f923ddaf35cc89349081d142
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp39-cp39-win32.whl
| Download URL | ceODBC-3.1-cp39-cp39-win32.whl |
|---|---|
| Size | 392.9 kB |
| Tags | CPython 3.9 Windows x86-32 |
|
SHA-256 checksum How to use checksums |
193bf580f1bcee0bd2d5e92c707db2252ba415d28d9d9703742b3820d65d0d6a
|
|
BLAKE2b-256 checksum How to use checksums |
d40ec7a273d1f2c297f267c093e7e3a4cf3e6f77d87898e3b6c5dc836ffa396e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
| Download URL | ceODBC-3.1-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl |
|---|---|
| Size | 2.0 MB |
| Tags | CPython 3.9 Linux glibc 2.17+ x86-64 |
|
SHA-256 checksum How to use checksums |
fac13acddc187f7dde44797388dce982295be967b473c0145c101314d081fb60
|
|
BLAKE2b-256 checksum How to use checksums |
ea701783d022ced4bf9b201982cc0c45cb70d32a0892b17d47b32bc9c9e3a3b8
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
| Download URL | ceODBC-3.1-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl |
|---|---|
| Size | 2.0 MB |
| Tags | CPython 3.9 Linux glibc 2.17+ ARM64 |
|
SHA-256 checksum How to use checksums |
4a2959fee7cce3867d55bcb596ad09f1d8e44186e34183301dc7d1406cbe7a37
|
|
BLAKE2b-256 checksum How to use checksums |
4d44a5f5e9cd215da39cc152ddf49df5d519bf15c3b1abdee3ae7786d2daeaaf
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp38-cp38-win_amd64.whl
| Download URL | ceODBC-3.1-cp38-cp38-win_amd64.whl |
|---|---|
| Size | 319.8 kB |
| Tags | CPython 3.8 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
62c5a1075065e1e01657ae1f5479d4a8e010642506dd8093e3bc2efb6193d19e
|
|
BLAKE2b-256 checksum How to use checksums |
db0e65230307296dd8f4f72352b0e64e9fb5e1bcdf7ed1cd8d6deeba4140b3a9
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp38-cp38-win32.whl
| Download URL | ceODBC-3.1-cp38-cp38-win32.whl |
|---|---|
| Size | 233.7 kB |
| Tags | CPython 3.8 Windows x86-32 |
|
SHA-256 checksum How to use checksums |
2362531d600a7ec6322eeef9a74f536b422fcf9da74be8938aada5e94ef8300a
|
|
BLAKE2b-256 checksum How to use checksums |
7f495ca1c879f955570510a844a369b50efd21c305c02c06253567f5c22ae657
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
| Download URL | ceODBC-3.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl |
|---|---|
| Size | 1.4 MB |
| Tags | CPython 3.8 Linux glibc 2.17+ x86-64 |
|
SHA-256 checksum How to use checksums |
f6345de9801a55eebf19f1e3a7d592c99244fb1ae214f8f617fe69ac61297c24
|
|
BLAKE2b-256 checksum How to use checksums |
4ca422f6d8b7ee17c4450a5cc81dd52e5fc9aa8f037ae71dd7fd3c31fb90f717
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
| Download URL | ceODBC-3.1-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl |
|---|---|
| Size | 1.4 MB |
| Tags | CPython 3.8 Linux glibc 2.17+ ARM64 |
|
SHA-256 checksum How to use checksums |
6fc5c622ac6a6ecccbb12380ae7b8da22559210190f474bf07adfc4281a1d503
|
|
BLAKE2b-256 checksum How to use checksums |
a1bd52f1b04aeb3be315c6bd3f22d218f068ddc7b6c69f438e0094a9ccd36f89
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp37-cp37m-win_amd64.whl
| Download URL | ceODBC-3.1-cp37-cp37m-win_amd64.whl |
|---|---|
| Size | 160.3 kB |
| Tags | CPython 3.7 CPython 3.7 pymalloc Windows x86-64 |
|
SHA-256 checksum How to use checksums |
9262ca4f92ce97b8c557d82dccccee2732c5149c884969977a47046ad84978ff
|
|
BLAKE2b-256 checksum How to use checksums |
391602ed074d4c8db5ac3a6c65136d435efe4281ce85d18d991c5929a9be24f3
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp37-cp37m-win32.whl
| Download URL | ceODBC-3.1-cp37-cp37m-win32.whl |
|---|---|
| Size | 76.4 kB |
| Tags | CPython 3.7 CPython 3.7 pymalloc Windows x86-32 |
|
SHA-256 checksum How to use checksums |
f899a73fdf37b7098d9bc295b080eb4162daf00d8df8df41dee890e7b046b3ab
|
|
BLAKE2b-256 checksum How to use checksums |
9dfccbbd896301150b2b6121d20bdbabb6aa946ceaefea5264b44463c06edc93
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
| Download URL | ceODBC-3.1-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl |
|---|---|
| Size | 747.9 kB |
| Tags | CPython 3.7 CPython 3.7 pymalloc Linux glibc 2.17+ x86-64 |
|
SHA-256 checksum How to use checksums |
82f407d3c80442365f83cd03cfb4a4391d4d8bfc2a84ecab787f44fe6821433f
|
|
BLAKE2b-256 checksum How to use checksums |
50d2945ed64c3d1d4dbf8371f5ecc864a7845ca7785057899df371548534a7a2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
Release files / ceODBC-3.1-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
| Download URL | ceODBC-3.1-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl |
|---|---|
| Size | 738.9 kB |
| Tags | CPython 3.7 CPython 3.7 pymalloc Linux glibc 2.17+ ARM64 |
|
SHA-256 checksum How to use checksums |
9b0edc528c69729b13676029e9eada18ea1293f6a4bf0a7fde8db5709fcaf749
|
|
BLAKE2b-256 checksum How to use checksums |
c3c5504dbdc9383703a9ab6227327062dc53de7bd2e8d12480d7a05776733776
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.1 CPython/3.11.0
|
