Database Toolbox

Setting Up a Data Source for ODBC Drivers

Follow this procedure to set up a data source for a PC running Windows whose database resides on that PC or on another system to which the PC is networked via ODBC drivers. This procedure uses as an example, the Microsoft ODBC driver Version 4.00 and the U.S. English version of Microsoft Access 2000 for Windows 2000. 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. When you first open the tutorial database (tutorial.mdb) in Access 2000, convert it to the Access 2000 format and assign it a different name, for example, northwind.mdb.
• SampleDB data source--Uses the Microsoft Access sample database called northwind. If you do not already have the sample database on your system, you can download it from the Microsoft Web site downloads page. It is part of the Access 2000 downloads and is the Northwind Traders sample database. When you first open the Northwind database (Nwind.mdb) in Access 2000, convert it to the Access 2000 format and save it. You may want to make a copy of the original unconverted tutorial database.

To set up the data source:

1. From the Windows Start menu, select Programs -> Administrative Tools -> Data Sources (ODBC).

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

   

2. Select the User DSN tab.

1. A list of existing user data sources appears.

3. Click Add. A list of installed ODBC drivers appears in the Create New Data Source dialog box.
4. 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 (*.mdb).
• Otherwise, select the driver for your database.

1. 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.

   

5. Provide a Data Source Name and Description.

1. For one example data source, type dbtoolboxdemo as the data source name.

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

6. 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.

• If your database resides on another system to which your PC is connected, you must first click Network. The Map Network Drive dialog box appears. Find and select the directory containing the database you want to use, and then click Finish. The Map Network Drive dialog box closes.

3. Click OK to close the Select Database dialog box.
7. In the ODBC Setup dialog box, click OK.
8. Repeat steps 3 through 7 to set up the data source for the other example database, northwind.
• In step 5, type SampleDB as the data source name.
• In step 6, select northwind.mdb. See "SampleDB data source" in Setting Up a Data Source for ODBC Drivers for instructions to obtain the data from Microsoft.
9. Click OK to close the ODBC Data Source Administrator dialog box, which now contains the dbtoolboxdemo and SampleDB data sources.

Setting Up a Data Source

Setting Up a Data Source for JDBC Drivers