Share via


ODBC DSN Entry for Xtreme Sample Database

A number of tutorials, which are found both in this documentation and in other help materials on the Business Objects Website, rely on the xtreme.mdb Microsoft Access database that is installed with Crystal Reports for Visual Studio.

The database is stored in your file directory, and it is accessed through ODBC by an ODBC DSN configuration in the Data Sources (ODBC) control panel.

In the previous section, you verified the location of the database. In this section, you verify the DSN configuration.

To verify the ODBC DSN configuration for connecting to the xtreme.mdb database

  1. In Control Panel, select Administrative Tools.

  2. Select Data Sources (ODBC).

  3. Select the tab System DSN.

  4. Locate the corresponding System DSN entry for your version of Crystal Reports from the table below.

  5. Confirm that the DSN entry exists on your system, and that it contains the correct name and path to the database.

  6. If the DSN entry does not exist, create a new System DSN entry according to the table below.

    Crystal Reports version
    System DSN name
    Path to xtreme.mdb
    Crystal Reports for Visual Studio .NET 2002
    Xtreme Sample Database
    C:\Program Files\Microsoft Visual Studio .NET\Crystal Reports\Samples\Database\xtreme.mdb
    Crystal Reports 9
    Xtreme Sample Database 9
    C:\Program Files\Crystal Decisions\Crystal Reports 9\Samples\En\Databases\xtreme.mdb
    Crystal Reports for Visual Studio .NET 2003
    Xtreme Sample Database 2003
    C:\Program Files\Microsoft Visual Studio .NET\Crystal Reports\Samples\Database\xtreme.mdb
    Crystal Reports 10
    Xtreme Sample Database 10
    C:\Program Files\Crystal Decisions\Crystal Reports 10\Samples\En\Databases\xtreme.mdb
    Crystal Reports 11
    Xtreme Sample Database 11
    C:\Program Files\Business Objects\Crystal Reports 11\Samples\En\Databases\xtreme.mdb
    Crystal Reports for Visual Studio 2005
    Xtreme Sample Database 2005
    C:\Program Files\Microsoft Visual Studio 8\Crystal Reports\Samples\En\Database\xtreme.mdb
    Crystal Reports Basic for Visual Studio 2008
    Xtreme Sample Database 2008
    C:\Program Files\Microsoft Visual Studio 9.0\Crystal Reports\Samples\En\databases\xtreme.mdb