-
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.
-
Re: ODBC DSN's
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