Database Toolbox

Setting Up a Remote Data Source for ODBC Drivers

Follow this procedure to set up a data source that resides on a remote system to which your PC has network access. This procedure uses the Microsoft ODBC driver Version 4.00.42 and the U.S. English version of Microsoft Access 97 for Windows NT installed on a networked server. If you have a different configuration, you may have to modify the instructions.

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

• dbtoolboxdemo data source - Uses the Microsoft Access 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.

The ODBC Data Source Administrator dialog box appears.

3. Select the System 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 remote 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 one shown in the following figure.

6. Provide a Data Source Name and Description.

For one of the example data sources, 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. Click Network.

The Map Network Drive dialog box appears.



3. Find and select the directory containing the database you want to use, and then click OK. The Map Network Drive dialog box closes.

For the dbtoolboxdemo data source, select the $matlabroot\toolbox\database\dbdemos directory.

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

In the example shown, the database is in SERVERS\APPLICATIONS\Applications.

4. Locate the database in the Select Database dialog box.

For the dbtoolboxdemo data source, select tutorial.mdb. For the SampleDB data source, select Northwind.mdb.

5. 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 Local Data Source for ODBC Drivers

Setting Up a Data Source for JDBC Drivers