??????????????VCд??????????Access??????????????????????????????????????????????Windows??????????????ODBC??OLE DB??ADO??Borland??BDE????ODBC(Open DataBase Connectivity)??????????????????????????????????????????OLE DB?????????????????ADO(ActiveX Data Objects)???????????????ODBC??ADO??
??????????ODBC?????????????????MFC??CDatabase?????????SQLConnect??ODBC??API?????????????afxdb.h
BOOL ODBCConnect(CString strDBFile)
{
CString strConnect;
strConnect.Format(_T("ODBC;DRIVER={MICROSOFT ACCESS DRIVER (*.mdb)};UID=sa;PWD=;DBQ=%s")?? strDBFile);
CDatabase db;
if(db.Open(NULL?? FALSE?? FALSE?? strConnect))
{
//???????????
CRecordset rs(&db);
CString strSql;
strSql = _T("select * from info");                                //SQL???
rs.Open(AFX_DB_USE_DEFAULT_TYPE?? strSql);                        //???Sql????????????????????
if(rs.IsOpen())
{
CDBVariant variant;
rs.MoveFirst();
while(!rs.IsEOF())
{
//??????
rs.GetFieldValue(_T("????")?? variant);
rs.MoveNext();
}
}
db.Close();
return TRUE;
}
return FALSE;
}