This link explains the problem: http://support.microsoft.com/default.aspx?scid=kb;en-us;272358
Unfortunately, I'm not sure what the solution is. I've already tried to create a transaction in a session. VJ On Mar 7, 2:05 pm, "vinjvinj" <[EMAIL PROTECTED]> wrote: > My first query works but the second query gets this error. I'm using > the db_conn.execute function to execute direct sql. I also tried to > create a session object and explicitly create a transaction and commit > the transaction thinking that might solve the problem. However, that > did not fix the problem. > > VJ > > Exception: > > adoRetVal=self.cmd.Execute() > File "<COMObject ADODB.Command>", line 3, in Execute > File "C:\Python24\Lib\site-packages\win32com\client\dynamic.py", > line 258, in > _ApplyTypes_ > result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, > retType, argTypes > ) + args) > com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft OLE DB > Provider > for SQL Server', 'Cannot create new connection because in manual or > distributed > transaction mode.', None, 0, -2147467259), None) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---