Hi!

You do not need an ODBC-driver. You can do this drictely with DAO too. Try the following:

CDaoDatabase OdbcDB;
CDaoRecordset *OdbcTable;

OdbcDb.Open("c:\\...your path to the ODBC source", FALSE, FALSE, "FoxPro 2.6; /*or another typ, see MSDN for the other definitions*/");

OdbcTable = new CDaoRecordset(&OdbcDb);

OdbcTable->Open(dbOpenDynaset, "select * from ...", dbSeeChanges);

/*-------------------------------*/
... or via ODBC-DSN
OdbcTable = new CRecordset(...);
OdbcTable->Open(dynaset, "ODBC;DSN=...", none | skipDeletedRecords);

I hope this will work.

Marc