64,654
社区成员
发帖
与我相关
我的任务
分享
void XXXXXXX::UpdataRemoteDB(CString sql)
{
try
{
//创建数据库连接
_ConnectionPtr m_pConnection;
//记录集
_RecordsetPtr m_pRecordset;
m_pConnection.CreateInstance(__uuidof(Connection));
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=cccc.mdb","","",adModeUnknown);
m_pRecordset->Open(sql, m_pConnection.GetInterfacePtr(),adOpenStatic,adLockOptimistic,adCmdText);//adOpenDynamic
if(m_pRecordset->State)
m_pRecordset->Close();
if(m_pConnection->State)
m_pConnection->Close();
}
catch(...)
{
}
return ;
}