[sqlalchemy] Re: error after insert using mssql and sqlalchemy 0.3.7

2007-05-25 Thread Jin Lee
Rick, Paul - Sorry for the late reply (my day job has been keeping me quite busy) It looks like ?use_scope_identity=0 works, I am no longer getting the error. Rick, to answer your questions, the pk is a field of type IDENTITY. I am using pyodbc 2.0.35, and MSSQL 2000 SP 4 Thanks guys, Jin

[sqlalchemy] error after insert using mssql and sqlalchemy 0.3.7

2007-05-23 Thread Jin Lee
Hello list, I am a newbie to sqlalchemy and have been playing around with it in a windows environment w/ mssql. I keep getting this error after I do an insert. The insert is successful, but I think there is a problem in getting the pk afterward. Thank you very much, Jin Lee import pyodbc