使ç¨ADOæ¹æ³è®¿é®accessæ°æ®åºï¼
使ç¨ADOè¿æ¥æ°æ®åºæ¯éè¿Connection对象çOpenæ¹æ³å®ç°çï¼è¯æ³æ¯ï¼
Connection.Open Connectionstring.userID.password,openoptions
åæ°è¯´æï¼
Connectionstring:(å¯é)å符串ï¼å
å«è¿æ¥ä¿¡æ¯
userIDï¼ï¼å¯éï¼å符串ï¼å
å«è¿æ¥æ¶æ使ç¨çç¨æ·å称
passwordï¼ï¼å¯éï¼å符串ï¼å
å«å»ºç«è¿æ¥æ¶å¤ç¨å¯ç
openoptions:(å¯é)ConnectoptionEnumå¼ï¼å¦æ设置为adConnectoAsyncï¼åå¼æ¥æå¼è¿æ¥ãå½è¿æ¥ãå½è¿æ¥å¯ç¨æ¶å°äº§çConnectCompleteäºä»¶
å
·ä½çå®ç°æ¹æ³å¦ä¸ï¼
void CConnectDlg::OnInitADOConn()
{
try
{
//å建è¿æ¥å¯¹è±¡å®ä¾
m_pConnection.CreateInstance("ADODB.Connection");
//设置è¿æ¥å符串
CString strConnect="DRIVER={Microsoft Access Driver (*.mdb)};\
uid=;pwd=;DBQ=shujuku.mdb;";
//使ç¨Openæ¹æ³è¿æ¥æ°æ®åº
m_pConnection->Open((_bstr_t)strConnect,"","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox(e.Description());
}
}
void CConnectDlg::ExitConnect()
{
//å
³éè®°å½éåè¿æ¥
if(m_pRecordset!=NULL)
m_pRecordset->Close();
m_pConnection->Close();
}
è³äºè§é¢çæç没æäºï¼åµåµï¼ä½ 个å°åï¼æä¹å¼èµ·æ°æ®åºæ¥äº
温馨提示:答案为网友推荐,仅供参考