Database Toolbox

Setting Up a Local Data Source for ODBC Drivers

Follow this procedure to set up a local data source for a PC. This procedure uses as an example, the Microsoft ODBC driver Version 4.00.42 and the U.S. English version of Microsoft Access 97 for Windows NT. If you have a different configuration, you may have to modify the instructions.

If you have Microsoft Access installed and want to use many of the examples in this document as written, set up these two data sources:

• dbtoolboxdemo data source - Uses the tutorial database provided with the Database Toolbox in $matlabroot\toolbox\database\dbdemos
• SampleDB data source - Uses the Microsoft Access sample database called Northwind

1. From the Windows Start menu, select Control Panel from the Settings menu.
2. Double-click ODBC Data Sources.

The ODBC Data Source Administrator dialog box appears, listing any existing data sources.

3. Select the User DSN tab.

A list of existing system data sources appears.

4. Click Add. A list of installed ODBC drivers appears in the Create New Data Source dialog box.
5. Select the ODBC driver that the local data source you are creating will use and click Finish.
• For the examples in this book, select Microsoft Access Driver.
• Otherwise, select the driver for your database.

The ODBC Setup dialog box appears for the driver you selected. Note that the dialog box for your driver might be different from the following.

6. Provide a Data Source Name and Description.

For the first example data source, type dbtoolboxdemo as the data source name. For the other example data source, type SampleDB as the data source name.

Note that for some databases, the ODBC Setup dialog box requires you to provide additional information.

7. Select the database that this data source will use. Note that for some drivers, you skip this step.
1. In the ODBC Setup dialog box, click Select.

The Select Database dialog box appears.



2. Find and select the database you want to use.

For the dbtoolboxdemo data source, select tutorial.mdb in $matlabroot\toolbox\database\dbdemos.

For the SampleDB data source, select Northwind.mdb in the msoffice\...\Samples directory.

3. Click OK to close the Select Database dialog box.
8. In the ODBC Setup dialog box, click OK.
9. Click OK to close the ODBC Data Source Administrator dialog box.

Setting Up a Data Source

Setting Up a Remote Data Source for ODBC Drivers