manual or distributed transaction mode

• mtmingus

  SSC Veteran

  Points: 275

  More actions

  September 27, 2002 at 11:51 am

  #58036

  Sometimes I got error in my ADO/Cplusplus code:

  Code = 80004005

  Code meaning = Unspecified error

  Source = Microsoft OLE DB Provider for SQL Server

  Description = Cannot create new connection because in manual or distributed transaction mode.

  then followed by:

  Error number: 8000ffffITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state.

  would remove the explicit transaction help?

  ...

  _RecordsetPtr pRst = NULL;

  _CommandPtr pCmd = NULL;

  _ConnectionPtr pConn = NULL;

  ...

  pRst->CursorType = adOpenStatic;

  pRst->CursorLocation = adUseClient;

  pRst->LockType = adLockReadOnly;

  ...

  pConn->BeginTrans(); // to be removed?

  pCmd->PutActiveConnection(_variant_t((IDispatch*)pConn));

  pRst = pCmd->Execute(NULL,NULL,adCmdText);

  pConn->CommitTrans(); // to be removed?

  ...

  your insights are appreciated.

  Zack Hu

• Andy Warren

  SSC Guru

  Points: 119747

  More actions

  September 27, 2002 at 12:13 pm

  #437412

  Might want to try a C++ centric site.

  Andy

  http://qa.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter