请教连接mdb数据库问题

[yschat2012]

下面代码有什么问题,怎么连接不了ChargeDB.mdb?

BOOL CDBBase::OpenDatabase()
{
	HRESULT hr = S_OK;
	m_pConnection.CreateInstance("ADODB.Connection"); 

	try{
		
		if( m_pConnection==NULL )
			TESTHR(m_pConnection.CreateInstance(__uuidof(Connection)));

		if( m_pConnection->GetState()==adStateClosed )

		
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=ChargeDB.mdb", "","",adModeUnknown); 
	}catch(_com_error& e){

		CloseDatabase();
		LOG_Write(g_hLog,"CDBBase::OpenDatabase failed:%s",e.ErrorMessage());
		return false;
	}
	return true;
}

[zgl7903]

可能当前路径并不是你想要打开文件的路径，构造绝对路径试试看

[oyljerry]

查看一下错误信息。

[yschat2012]

数据库和程序是同一目录

[erick08]

	CoInitialize(NULL);

	CString strSql(_T(""));
	_ConnectionPtr pConn(__uuidof(Connection));
	_RecordsetPtr pRst(__uuidof(Recordset));
	CString strConn(_T(""));
	
	strSql.Format("select xxx from xxx_tb where id = '101'");

	CString strFile;
	strFile.Format("C:\\test.mdb");

	strConn.Format("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=%s", strFile);

	pConn->ConnectionString = _bstr_t(strConn);
	try
	{
		if ( pConn->Open("", "", "", adCmdUnspecified) != 0 )
			return FALSE;		
		pRst->Open(_variant_t(strSql), _variant_t(pConn,true), adOpenDynamic, adLockPessimistic, adCmdText);
		...
	}
	...