数据库已经联接上,而且txtSQL已经在SQL中运行是正确,但为何这样执行总是返回FALSE.请大侠赐教!
_variant_t RecordsAffected;
try
{
if(SUCCEEDED(m_pConnection->Execute(_bstr_t(txtSQL),&RecordsAffected,adCmdText)))
return TRUE;
}
catch (_com_error e)
{
TRACE(_T(":( 数据库执行错误: %s\n"), e.ErrorMessage());
return FALSE;
}
--------------用ADO的方法如下,在Open处报错?----------------
try
{
m_pRecordSet->Open(_variant_t("SELECT * FROM Plate_"+ mstr), // 查询DemoTable表中所有字段
m_pConnection.GetInterfacePtr(), // 获取库接库的IDispatch指针
adOpenDynamic,
adLockOptimistic,
adCmdText);
m_pRecordSet->AddNew();
m_pRecordSet->PutCollect("Come_Datetime", _variant_t(plate.GetDateTime()));
m_pRecordSet->PutCollect("Plate_Number", _variant_t(plate.GetPlateCode()));
m_pRecordSet->PutCollect("plate_Type", _variant_t(plate.GetPlateType()));
m_pRecordSet->PutCollect("Image_Path", _variant_t(plate.GetFileName()));
m_pRecordSet->PutCollect("SrcComputer", _variant_t(plate.GetLocalIP()));
m_pRecordSet->PutCollect("Car_Position", _variant_t(plate.GetChannelID()));
m_pRecordSet->Update();
m_pRecordSet->Close();
return TRUE;
}
catch(_com_error *e)
{
TRACE(_T(":( 数据库执行错误: %s\n"));
return FALSE;
}