測試數據庫連接


_ConnectionPtr m_pConnection;
m_pConnection=NULL;
if(!oleinit)
{
try
{
if (!AfxOleInit())
{
//AfxMessageBox("ole 初始化錯誤");
return false;
}
}
catch(...)
{}
}
oleinit=true;
m_pConnection.CreateInstance(__uuidof(Connection));
// CString dbPath=m_AppPath+"\\DATABASE\\DB_P.mdb";
m_strConnection = _T("Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=ahryDB;Data Source=LH”);
try 
{ 
//打開本地Access庫DZBL邊坡數據庫.mdb,可以做成活得
m_pConnection->Open((LPCTSTR)m_strConnection,
"","",adModeUnknown);
}
catch(_com_error e)
{
//AfxMessageBox("數據庫連接失敗，請確認數據庫‘DB_P.mdb’路徑!");
return false;
} 
m_pConnection=NULL;
return true;