[IronPython] adodbapi 2.2 ready for Iron Python (ADO DB using dbapi 2.0 compliant SQL interface)

[Vernon Cole]

Dear Pythonoholics:

Testing is complete. The code changes needed constitute version 2.2 of
adodbapi.
 Any unit test failures in adodbapi remaining at this point have been
submitted to codeplex as bug reports. The following features will not work
(or will work incorrectly) until some future version of ipy.
 1) some times will be incorrect in old python "import time" data. (datetime
works correctly.)
 2) You cannot use binary data (BLOB) as a parameter.
 3) You cannot use a Long integer as a parameter.
 4) You may try changing CommandTimeout, but it will not do anything.
--
That being said:
  adodbapi is a fully dbapi 2.0 compliant package for accessing SQL data,
written in pure python.
  It runs in either C python or Iron Python (Windows only - it depends on
COM).
  All data is read and/or written using appropriate native python data types
such as datetime.datetime (for dates) and decimal.Decimal (for currency and
numeric).
  You may change the type conversions if you wish.
  Everything works -- commit/rollback, stored procedures, multiple dataset
return, etc, etc.
  Tested with Jet (MS Access), MS SQL server, and mySQL engines. Probably
works with any other suitable ADO DB source.
It will be released (later) as part of both pywin32 and fepy.
You can get it now at http://sourceforge.net/projects/adodbapi . Put the
unzipped folder in your /lib/site-packages directory.
--
Any comments or bug reports can be sent here or to the pywin32 mailing list.
If you put them on the tracker at sourceforge, I may get to them eventually,
but I don't check it often.
--
Vernon Cole
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ironpython-users/attachments/20080828/4128cbf4/attachment.html>