ODBC DSN's

I've got a program which needs to preview data which is stored in a variety of database formats. The user selects the file and then the program needs to open the database and read the headings and a sample of the data to display in a grid. If I were to use ODBC is there anyway to specify the DSN through code, or does the user have to go through the control panel to do this?

Cheers,
Craig.

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