SQL Server Requery() sometimes hangs

Posted by PSU on Programmers See other posts from Programmers or by PSU
Published on 2012-09-17T21:35:43Z Indexed on 2012/09/17 21:51 UTC
Read the original article Hit count: 99

Filed under:

I have an issue with Visual C++ and Microsoft SQL Server 2008R2.

The following code will occasionally hang:

  Object->Update();

  if(Object->CanRestart())
  {
     //Why does this not return??
     m_pDBRoRBaseObject->Requery();
  }

Object is derived from CRecordset. It looks to me as though a call to ::SQLExecute(m_hstmt) in the Requery() method is hanging, but I can't (with my current skill set anyway) figure out a way around this. Has anyone had a similar problem, or an insight of any sort?

© Programmers or respective owner

Related posts about sql-server