Table of Contents Previous Section

Using Microsoft Access

 Read this section if you want to use Enterprise Objects Framework to connect to a Microsoft Access database. The information in this section describes what you need to do before you can install the sample databases or create your own custom databases.

What You Need

Enterprise Objects Framework uses ODBC (a standard API developed by Microsoft for accessing database management systems) to interact with Access databases, so you'll need an Access-specific ODBC driver if you don't have one already.

To determine if you've already got an ODBC driver installed, open the Control panel. If there isn't an ODBC option listed, then you don't have any ODBC drivers installed. You can download the latest version from the Microsoft website by doing the following:

  1. Open the URL http://www.microsoft.com/kb/softlib/default.asp

  2. Ensure that "I would like to see all files available for a product" is selected.

  3. Click Next.

  4. Choose ODBC from the list.

  5. Click List Files.

  6. Click ODBC Desktop Database Drivers 3.5.

Creating Data Sources and Databases

 After you've installed an ODBC driver for Access, you'll need to create databases and corresponding data sources for them. A data source simply stores the information needed to connect to your database. The easiest way to create an Access database and a corresponding data source from scratch is to create them both at the same time with the ODBC Data Source Administrator:

  1. Choose the ODBC option in the Control Panel.

    An ODBC Data Source Administrator panel opens.

  2. Click the System DSN tab.

    System data sources are accessible to all users, including NT services. It's important to create system data sources instead of user data sources, especially for use with WebObjects, because autolaunched applications aren't able to access user data sources.

  3. Click Add.

    An Create New Data Source panel opens.

  4. Select the Microsoft Access Driver.

  5. Click Finish.

    An ODBC Microsoft Access 97 Setup panel opens.

  6. Type a name for your data source in the Data Source Name field (Movies, for example).

    Remember the name you provide because later you'll it to login to your database.

  7. In the Database section of the panel, click Create.

    A New Database panel opens. You'll use this panel to create a new, empty database.

  8. Type a name for your database in the Database Name field (Movies.mdb, for example).

  9. Choose a directory where you want the database located.

  10. Click OK.

    A panel opens telling you that the database was successfully created.

  11. In the ODBC Microsoft Access 97 Setup panel, click OK.

    Your database and data source are now ready to use. If you want to populate the new database with one of the sample databases that come with WebObjects, you've completed the first step: setting up the database accounts. To find out what to do next, see "Installing the Movies and Rentals Sample Databases."

Table of Contents Next Section