///创建数据库连接
try{
m_pConnection.CreateInstance("ADODB.Connection");
CString strSRC;
CString DBPATH("C://F.MDB");
strSRC="Provider=Microsoft.JET.OLEDB.4.0;Data Source=";
strSRC+=DBPATH+";Persist Security Info=False";
_variant_t varSRC(strSRC);
_bstr_t bstrSRC(strSRC);
//连接数据库
m_pConnection->Open(bstrSRC,"","",-1)
}
catch(_com_error &e)
{
AfxMessageBox(e.Description());
}
///创建ADOX相关对象
ADOX::_CatalogPtr m_pCatalog=NULL;
HRESULT hr=S_OK;
hr=m_pCatalog.CreateInstance(_uuidof(ADOX::Catalog));
if(FAILED(hr))
{ _com_issue_error(hr); }
m_pCatalog->PutActiveConnection(_variant_t ((IDispatch *)m_pConnection));
/表的个数
TRACE1("/n****** %d *****/n",m_pCatalog->Tables->Count);