解决办法:下载安装32位的access引擎 安装即可, vs工程选择win32。
数据库建立连接的过程:
1、导入dll,使用命名空间,在stdafx.h文件里面加上如下语句:
#import "C:\Program Files\Common Files\System\ADO\msado15.dll" rename("EOF","adoEOF"), rename("BOF","adoBOF")
2、在CWinApp类的BOOL CMyProgramApp::InitInstance()函数中添加初始化语句
AfxOleInit();///初始化COM库
AfxEnableControlContainer();
3、建立连接语句
在CWinDlg中添加两个成员变量,表中字段变量
_ConnectionPtr m_pConnection;
_RecordsetPtr m_pRecordset;//数据集连接
_variant_t vUsername,vID,vFeature; //存放取出来的数据的变量
建立连接:
HRESULT hr;
try
{
//CoInitialize(NULL);
hr = m_pConnection.CreateInstance("ADODB.Connection");///创建Connection对象
if(SUCCEEDED(hr))
{
//hr = m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= FaceData.mdb", "", "", adModeUnknown);
<span style="white-space:pre"> </span>//Access2013使用如下provider
hr = m_pConnection->Open("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= firstdb.accdb","","",adModeUnknown);///连接数据库
MessageBox(_T("成功连接数据库"));
//_bstr_t strConnection = _T("Provider=SQLOLEDB;DataSource=local;InitialCatalog=FaceData.mdf");
//hr = m_pConnection->Open(strConnection,"sa","123456",adModeUnknown);
//上面一句中连接字串中的Provider是针对ACCESS2000环境的,对于ACCESS97,
//需要改为:Provider=Microsoft.Jet.OLEDB.3.51; }
//_bstr_t ConStr = "Provider=SQLOLEDB;Server=(local);Database=FaceData;uid=sa;pwd=123456;";
//m_pConnection->Open(ConStr, "", "", NULL);
}
}
catch(_com_error e)///捕捉异常
{
CString errormessage;
errormessage.Format(_T("连接数据库失败!\r\n错误信息:%s"),e.ErrorMessage());
AfxMessageBox(errormessage);///显示错误信息
return ;
}
4、查询的处理函数:
void CMyProgramDlg::OnBnClickedSearch()
{
// TODO: 在此添加控件通知处理程序代码
CString CFeature;
try
{
CString strSQL;
//strSQL.Format("SELECT * FROM FaceTable where userid ='%s'",m_userID); // 有条件查找
//strSQL.Format(_T("SELECT * FROM users"));
strSQL.Format(_T("SELECT * FROM staffinfo"));
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->Open(_variant_t(strSQL), m_pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdUnknown);
int i = 0;
while(m_pRecordset->EndOfFile == VARIANT_FALSE && i < 100 )
{
//vFeature = m_pRecordset->GetCollect("feature");
vFeature = m_pRecordset->GetCollect("username");
CFeature += vFeature;
m_pRecordset->MoveNext();
i++; //选择读取前1个 测试用所以读的少点
}
MessageBox(CFeature);
}
catch(_com_error e)
{
CString message;
message.Format(_T("读取数据库失败!\n 错误信息为:%s"),e.Description());
AfxMessageBox( message );///显示错误信息
}
}