MFC数据库操作 - 连接退出

#import "C:/Program Files/Common Files/System/ado/msado15.dll" no_namespace rename("EOF", "adoEof")
首先进行com组件的初始化
_ConnectionPtr m_pConnection;
HRESULT hr;
try
{
hr = m_pConnection.CreateInstance(__uuidof(Connection));
if (SUCCEEDED(hr)) {
//_bstr_t connectStr = _T("Provider=SQLNCLI;Server=192.168.0.100;Database=DVDRentDB;Uid=cctry;Pwd=www.cctry.com");
_bstr_t connectStr = _T("Provider=sqloledb;Data Source=192.168.1.100;Initial Catalog=test1;User Id=sa;Password=550853006");
m_pConnection->ConnectionTimeout = 20;
hr = m_pConnection->Open(connectStr, _T(""), _T(""), adConnectUnspecified);
if (FAILED(hr)) {
MessageBox(_T("打开与数据库的连接失败."));
return;
}
if (SUCCEEDED(hr))
{
this->GetDlgItem(IDC_STATIC)->SetWindowText(_T("数据库连接成功！！"));
}
}else{
MessageBox(_T("实例化 Connection 对象失败."));
return;
}
}
catch (_com_error &e)
{
_bstr_t bstrSource(e.Source());
_bstr_t bstrDescription(e.Description());
MessageBox(bstrDescription, bstrSource);
return;
}

if (m_pConnection && m_pConnection->State == adStateOpen){
m_pConnection->Close();
this->GetDlgItem(IDC_STATIC)->SetWindowText(_T("数据库断开成功！！"));
}