beautypg.com

Pervasive – HP Intelligent Management Center Standard Software Platform User Manual

Page 722

background image

To translate information and data to and from DAO, the Report Designer
uses the DAO translation file crdb_dao.dll.

Secured Microsoft Access Databases

If you will be using secured Access databases, the SystemDB parameter in
the Windows Registry database must be set to point at the path where the
System.mdw (Access 95 and later) file is located. On Windows NT, the
SystemDB parameter is located in the following Registry key:

Access 97

\\HKEY_LOCAL_MACHINE\Software\Microsoft\Office\8.0\Access\Jet\3.5\Engines

Access 2000

\\HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Access\Jet\4.0\Engines

Pervasive

Crystal Reports connects to the Pervasive (formerly Btrieve) engine through
the translation files crdb_p2bbtrv.dll, p2bbtrv.dll, and p2ctbtrv.dll.

The Pervasive engine is a complex collection of DLLs and EXEs that are
specific to the version of Pervasive you are using. For more information on
the different Pervasive engine files, refer to your Pervasive documentation.

Note:

Pervasive must be configured correctly for Crystal Reports to read
Pervasive databases. If Pervasive is already configured correctly on your
system, Crystal Reports can use your Pervasive data immediately upon
installation. Crystal Reports automatically installs the Pervasive files that
it requires to read Pervasive data. Refer to your Pervasive documentation
to make sure the Pervasive engine is configured correctly.

When you open a Pervasive database, Crystal Reports opens the entire
database and loads information about all the tables in the database. To
do this, Crystal Reports must reserve a large section of your computer's
memory, called a buffer, in advance. Computer memory restrictions limit
this buffer to 65,536 bytes (64K). This restricts the size of your Pervasive
database to about 80 tables, depending on the number of fields in each
table.

722

Crystal Reports 2008 SP3 User's Guide

Accessing Data Sources

26

Direct access database files