连接的sqlserver数据库.
m_pMsDb = new CDaoDatabase;
m_pMsDb->Open(NULL,FALSE,FALSE, _T("ODBC;DRIVER={SQL Server}; Server=(local); DATABASE = HKDW; UID=admin;PWD=123"));
if(!m_pMsDb->IsOpen())
return;CDaoRecordset rs(m_pMsDb);
CString strRs;strRs = _T("select * from Ms_HtmlElement where MS_Id like '") + strID + _T("'");
rs.Open(AFX_DAO_USE_DEFAULT_TYPE,strRs,NULL);
if(rs.IsEOF())
return;
while(!rs.IsEOF())
{
rs.Delete();
rs.MoveNext();
}删除的时候抛出异常"由于您和其他用户试图同时改变同一数据,
导致MicroSoft Jet 数据库引擎停止进程"
m_pMsDb = new CDaoDatabase;
m_pMsDb->Open(NULL,FALSE,FALSE, _T("ODBC;DRIVER={SQL Server}; Server=(local); DATABASE = HKDW; UID=admin;PWD=123"));
if(!m_pMsDb->IsOpen())
return;CDaoRecordset rs(m_pMsDb);
CString strRs;strRs = _T("select * from Ms_HtmlElement where MS_Id like '") + strID + _T("'");
rs.Open(AFX_DAO_USE_DEFAULT_TYPE,strRs,NULL);
if(rs.IsEOF())
return;
while(!rs.IsEOF())
{
rs.Delete();
rs.MoveNext();
}删除的时候抛出异常"由于您和其他用户试图同时改变同一数据,
导致MicroSoft Jet 数据库引擎停止进程"
我如果连接的是ACCESS数据库就没问题.为什么SQLSERVER就不行呢?