To set up an ODBC data source

Step 1: Go Start > Settings > Control Panel.

Step 2: Double-click on the ODBC Data Sources icon. This starts up ODBC Data Source Administrator dialog. ODBC requires that any database you wish to use is added as either a user DSN (if you want it to be available to you only) or a system DSN (if you want it to be available to all users on this machine). Depending on your preference, you must now select the User DSN or the System DSN Tab.

The ODBC Data Source Administrator

Step 3: Click Add. This fires up the 'Create New Data Source' dialog. (A data source is essentially a link to an existing database).

Create a new Data Source

Step 4: Select your database driver, for example, the Microsoft Access Driver (This requires Microsoft Access to be installed). Click Finish.

Database name, description and selection

Step 5: In the ODBC Microsoft Access 97 Set-up dialog, give the database a name and description, then click Select and select the database file. Click OK, and exit the ODBC Data Source Administrator. Your data source is now set up!


Home Contents Previous