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 On 5/24/07, Paul Johnston <[EMAIL PROTECTED]> wrote: > > Hi Jin, > > >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. > > > > > Yes, I'm afraid this is a known bug in 0.3.7. A workaround is to specify > ?use_scope_identity=0 at the end of your database URL. > > Paul > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---