manual or distributed transaction mode.

• mtmingus

  Old Hand

  Points: 335

  More actions

  September 27, 2002 at 12:42 pm

  #79320

  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: 8000ffff ITransaction::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: 119902

  More actions

  September 29, 2002 at 4:39 am

  #437440

  Suggest you try a C++ centric web site, or maybe the MS ADO newsgroup. Sorry we cant help more than that.

  Andy

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

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