//备份可以,但是还原不行。。
void CMyDlg::OnBackup()
{
// TODO: Add your command handler code here
try
{ m_pConnection.CreateInstance("ADODB.Connection");
CString strConnect="Provider=MSDASQL.1;Persist Security Info=False;Data Source=sql1;Initial Catalog=YWGL1";
m_pConnection->Open((_bstr_t)strConnect,"","",adModeUnknown);
_bstr_t vSQL;
vSQL = "BackUp database YWGL1 to disk= 'D:\\BackUp\\YWGL1.bak'";
m_pConnection->Execute(vSQL,NULL,adCmdText);
AfxMessageBox("备份数据库完成!");
return;
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
return ;
}
if (m_pRecordset != NULL)
m_pRecordset->Close();
m_pConnection->Close();
// 释放环境
::CoUninitialize();
}void CMyDlg::OnRestrore()
{
// TODO: Add your command handler code here
try
{
if (m_pRecordset != NULL)
m_pRecordset->Close();
// m_pConnection->Close();
// 释放环境
// ::CoUninitialize();
// CoInitialize(NULL);
// AfxOleInit();
m_pConnection.CreateInstance("ADODB.Connection");
// CString strConnect="Provider=MSDASQL.1;Persist Security Info=False;Data Source=mm;Initial Catalog=master";
_bstr_t strConnect="Provider=MSDASQL.1;Persist Security Info=False;Data Source=mm";
m_pConnection->Open(strConnect,"","",adModeUnknown);
_bstr_t vSQL;
vSQL = "restore database YWGL1 from disk= 'D:\\BackUp\\YWGL1.bak'";
m_pConnection->Execute(vSQL,NULL,adCmdText);
AfxMessageBox("还原数据库完成!");
return;
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
return ;
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货