User`s guide

2 Getting Started with Database Toolbox
2-18
data sources a user defines under System DSN on a machine can be seen by any user
who logs into that machine. Your ability to set up a User DSN or System DSN might
depend on the database and ODBC driver you are using. For details, contact your
database administrator or your database ODBC driver documentation.
5
A list of installed ODBC drivers appears in the Create New Data Source dialog box.
Select Microsoft Access Driver (*.mdb, *.accdb) and click Finish.
6
In the ODBC Microsoft Access Setup dialog box for your driver, enter
dbtoolboxdemo as the data source name. Enter tutorial database as the
description. Click Select to open the Select Database dialog box.
7
Specify the database you want to use. For the dbtoolboxdemo data source, select
tutorial.mdb. If your database is on a system to which your PC is connected:
a
Click Network.
b
In the Map Network Drive dialog box, specify the folder containing the database
that you want to use.
c
Click Finish.
8
Click OK to close the Select Database dialog box. In the ODBC Microsoft Access
Setup dialog box, click OK. The ODBC Data Source Administrator dialog box
displays the dbtoolboxdemo and any additional data sources that you added in the
User DSN tab. Click OK to close the dialog box.
9
Test the connection to the data source by using Database Explorer to connect to the
database.