[sqlalchemy] "business object" backend

hello all, We are using "business object" , a decisionnal layer upon our databases. I can connect to BO backend with odbc and execute sql order. is SQLAlchemy is able to connect to an ODBC driver other than MSSQL driver? I try also with mysql odbc driver unsuccessfully. thanks for your answ

[sqlalchemy] simple question on select_by with datetime object end mysql

helo SQLAlchemylist, I want to purge my mysql database and delete record selected by date with a select_by In [56]: query_etats.selectfirst().create_date Out[56]: datetime.datetime(2007, 7, 31, 17, 24, 32) In [57]: madate Out[57]: datetime.datetime(2007, 8, 21, 18, 33, 9, 542421) In [58]: pr

[sqlalchemy] Re: SQLAlchemy 0.4 beta5 (OperationalError) database table is locked '\nDROP TABLE os' () sqlite 3.4.2

j > Here you're holding onto open cursors with 'something == > ordinateurs.fetchone()'. Either explicitly close() the two result sets > you're accessing with fetchone() or remove your reference to the rows > and python gc will get around to closing the cursors at some point. > > ok thanks.

[sqlalchemy] SQLAlchemy 0.4 beta5 (OperationalError) database table is locked '\nDROP TABLE os' () sqlite 3.4.2

helo, I don't understand why my sqlite database is locked on a drop ( the code is following) thanks for your explanation. 007-09-14 18:26:36,375 INFO sqlalchemy.engine.threadlocal.TLEngine.0x..f0 ROLLBACK Traceback (most recent call last): File "C:\Python25\Lib\site-packages\pythonwin\pywin