The list of data sources that are specified in the ODBC Control Panel dialog box can be retrieved under program control. The verb ddsrc requests this information. In J Win95, the result is the list of data sources; in J Win31, the result is a statement handle that may be used with ddfet to return the list of data sources.
ddsrc'' +----------------------+------------------------------------+ |MS Access 7.0 Database|Microsoft Access Driver (*.mdb) | +----------------------+------------------------------------+ |Excel Files |Microsoft Excel Driver (*.xls) | +----------------------+------------------------------------+ |FoxPro Files |Microsoft FoxPro Driver (*.dbf) | +----------------------+------------------------------------+ |Text Files |Microsoft Text Driver (*.txt; *.csv)| +----------------------+------------------------------------+ |dBASE Files |Microsoft dBase Driver (*.dbf) | +----------------------+------------------------------------+ |jdata |Microsoft dBase Driver (*.dbf) | +----------------------+------------------------------------+
The result will depend on the drivers you have set up. Note that you should see an entry for jdata, which is the data source name you assigned to the examples\data subdirectory.
The result has 2 columns: the data source name, and a description of the driver.