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.5 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


Binary Install
--------------
Place the file ceODBC.pyd or ceODBC.so anywhere on your Python path.


Source Install
--------------
For simplified installation use pip

    pip install ceODBC

Otherwise, you can use the provided setup.py to build and install the module

    python setup.py build
    python setup.py install

If you wish to use cx_Logging for logging, run these commands instead:

    python setup.py build_ext --with-cx-logging --cx-logging <SourceDir>
    python setup.py install

The following packages are required on Linux before compilation is possible:

    python-devel
    unixODBC
    unixODBC-devel


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