The module was included as part of pywin32 version 211 and later.
Here are some key features of "ADODBAPI":
· 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)
Requirements:
· Python 2.3 or higher
· IronPython 2.6 or higher
What's New in This Release: [ read full changelog ]
· 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)
Find us on Google+
