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
_______________________________________________ Users mailing list [email protected] http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
