[Ironpython-users] Announcing adodbapi version 2.6

Vernon D. Cole vernondcole at gmail.com
Sun May 4 11:43:14 CEST 2014

Active Data Objects Data-Base Application Program Interface is a PEP-249
compliant SQL database package which will work with a large number of
tabular data sources.  It is tested using a Microsoft SQL Server database,
along with PostgreSQL, MySQL and Jet (Microsoft ACCESS) databases.  An
included example manipulates an .xls spreadsheet using SQL commands.

Although adodbapi continues to lead in development and standardization of
API extensions (such as referencing data columns by name), version 2.6 is
mostly a maintenance release with some refactoring, and only a few new

It now supports prepared SQL statements using a simple interface. For

> conn = adodbapi.connect('your connection string here')
> crsr = conn.cursor()
> crsr.prepare('some SQL statement where ? = ?')
> for parameters in sequence_of_parameter_sequences:
    crsr.execute(crsr.command, parameters)

In addition to the conjectured db-api version 3 standard of requiring SQL
parameter "paramstyles" of 'qmark' and 'numeric' , version 2.6 extends the
list to ['qmark', 'numeric', 'format', 'pyformat', 'dynamic'].  Switching
between sequences of parameters, and dictionaries of parameters, is dynamic
for some paramstyles.  [If you don't know what a 'paramstyle' is, it might
be better to remain oblivious.  ;-)   ]

Lightweight documentation athttp://adodbapi.sourceforge.net/quick_reference.pdf

Project at https://sourceforge.net/projects/adodbapi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ironpython-users/attachments/20140504/823fcd2d/attachment.html>

More information about the Ironpython-users mailing list