Common odbc database formats, Access – HP Intelligent Management Center Standard Software Platform User Manual

Page 736

Advertising
background image

For example, if you have installed the Informix database client, select
Informix from the Data Access folder.

5.

Click the selected data access option and choose Entire feature will be
unavailable
.

An X appears next to the option and the Feature Description area includes
a remark that the feature will be completely removed.

6.

Click Next on this dialog box and the following one.

The data access option you selected is removed.

7.

Repeat steps 2 through 4.

8.

Click the selected data access option and choose Will be installed on
local hard drive
.

The X next to the option is removed and the Feature Description area
includes a remark that the feature will be installed.

9.

Click Next on this dialog box and the following one.

The data access option you selected is reinstalled and its ODBC DSN is
configured properly.

Common ODBC database formats

Access

Although Microsoft Access files can be opened directly by Crystal Reports
(see

Microsoft Access

), you may wish to use ODBC for these files instead.

When communicating with Access databases, ODBC uses a translation file
that communicates with the Microsoft Jet Database Engine through the DAO
(see

DAO

). The Jet Database Engine is an example of a DBMS-specific

ODBC driver.

The Jet engine is the part of the Access DBMS that does all of the actual
work with an Access database. Jet is a required component for working with
Access data. Since the Jet engine is an integral part of all Access databases,
it is shown here as part of the database layer.

736

Crystal Reports 2008 SP3 User's Guide

Accessing Data Sources

26

ODBC data sources

Advertising