为什么我不能执行SQL语句
hanzp 2003-04-25 06:35:39 CDatabase* m_pDB;
strConnect = "Driver={Microsoft Access Driver (*.mdb)};DBQ=F:\\VC\\test\\v2\\disk.mdb;";
m_pDB = new CDatabase();
if( m_pDB->OpenEx( _T(strConnect) , CDatabase::noOdbcDialog) )
{
m_isDBConnected = true;
}
else
{
return -1;
}
CRecordset* pRS = new CRecordset(m_pDB);
pRS->m_pDatabase->ExecuteSQL("select * from UserInfo");
CString MSG;
MSG.Format("there are %d records", pRS->GetRecordCount());
MessageBox(MSG);
delete pRS;
return 1;
执行到
MSG.Format("there are %d records", pRS->GetRecordCount());
就出错了