Kent Johnson wrote: > Michael Bayer wrote: >> SQLAlchemy should be working with a DBAPI that has auto-commit turned >> off; this is because the Connection object supports its own "auto >> commit" feature. > > OK, I'll look into reworking mssql to assume that adodbapi connects to a > DB with autocommit off.
I have a version of mssql that works OK with an unmodified adodbapi - at least it commits changes! The reflection stuff is still problematic - even with the cursor change there are problems detecting identity fields and some of the reflect unit tests fail with errors like Multiple identity columns specified for table 'engine_multi'. Only one identity column per table is allowed. pymssql has the same problems with the reflection test... I'm not sure what to do with the changes?? I can put a diff somewhere but it will have the changes for datatypes also. Should I just make a new Trac ticket and upload the patch there? Kent ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users