ADODBAPI 2.4.3

Developer: Website: License / Price: Platforms: Databases: Language: Last Updated: Category: Henrik Ekelund | More scripts adodbapi.sourceforge.net LGPL - GNU Lesser General Public License  Windows / Linux / Mac OS / BSD / Solaris MSSQL / MySQL / PostgreSQL / Access Python April 1st, 2013, 03:49 GMT [view history] C: \ Database Tools

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 ]

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

Via: ADODBAPI 2.4.3