ADODBAPI

The module was included as part of pywin32 version 211 and later.

Features:

• Tested using ACCESS, MS SQL, MySQL and PostgreSQL.
• Can retrieve SQL data by column name or number.
• Change paramstyle to 'qmark', 'format', or 'named'.
• 100% DB-API 2.0 compliant.
• Includes pyunit testcases that describe how to use the module.
• Fully implemented in Python. -- runs in Python 2.3+ Python 3.0+ and IronPython 2.6+
• Supports eGenix mxDateTime, Python 2.3 datetime module and Python time module.
• Supports user-definable system-to-Python data convertion functions (selected by ADO data type, or by column)

What is new in this release:

• Remote module: (works on Linux!) allows a Windows computer to serve ADO databases via PyRO
• Server module: PyRO server for ADO. Run using a command like= C:>python -m adodbapi.server (server has simple connection string macros: is64bit, getuser, sql_provider, auto_security)
• Brief documentation included. See adodbapi/examples folder adodbapi.rtf
• Vastly refactored. Data conversion things have been moved to the new adodbapi.apibase module.
• Many former module-level attributes are now class attributes. (Should be more thread-safe)
• Connection objects are now context managers for transactions and will commit or rollback.
• Cursor objects are context managers and will automatically close themselves.
• Autocommit can be switched on and off.

What is new in version 2.4.3:

• Extensively reworked test folder (easier to test Python 3.3) creates and uses temporary folder
• Bug Fix for data type adGUID (from Allan "alkamo")
• Bug Fix for odd-length BINARY objects (from Pawel Jasinski) [also reduces traffic to server]
• New module adodbapi.is64bit: is64bit.Python() --> boolean is64bit.os() --> boolean
• New module adodbapi.schema_table: call using schema_table.names(anOpenConnection) --> list of tables in db.
• New improved /examples folder showing SQL used for ACCESS db and Excel .xls files.

What is new in version 2.4.2.2:

• The cursor has a new .query attribute. It returns the (possibly converted) query sent to ADO.
• This may be useful for testing paramstyle 'format' and 'named' queries. .query is an extension borrowed from psycopg2.
• Added .command and .parameters attributes, which are copies of the original command and parameters sent the the cursor.
• Added tests using a PostgreSQL server. Tests are now run for ACCESS, MS SQL, MySQL and PostgreSQL.
• Column name data access is now case insignificant (since PostgreSQL returns lower case column names). So (if a row object 'r' contains a first column 'spam') r[0], r.Spam, r.spam and r['SPAM'] are all equivalent.
• The connection has new attributes .dbms_name and .dbms_version to display the underlying database engine. (like mxODBC)

What is new in version 2.4.2.1:

• Added .command and .parameters attributes, which are copies of the original command and parameters sent the the cursor.
• Added tests using a PostgreSQL server. Tests are now run for ACCESS, MS SQL, MySQL and PostgreSQL.
• Column name data access is now case insignificant (since PostgreSQL returns lower case column names).

Requirements:

• Python 2.3 or higher
• IronPython 2.6 or higher