Advanced Installation Customizations

This section details using advanced customization for your embedded installations of Pervasive PSQL v10. Pervasive PSQL supports the following methods for advanced installation customizations:

Changing Installation Package Size and Features Using CAB Files

Developing an Embedded Installation with Custom File Picking

Creating Transforms to Customize your Installation

Changing Installation Package Size and Features Using CAB Files

The Pervasive PSQL v10 installation includes cabinet (CAB) files that can be removed from your installation package to decrease the overall size of the installation package and avoid using unnecessary files. Removing these files automatically removes the corresponding feature from the list of available features in the graphical user interface during a custom setup.

Working with CAB Files and Future Updates

CAB files are located in the same directory as the MSI and Setup executables. CAB files beginning with an underscore (_) are required for that install type. For a complete list of required files by installation type, see Required Files .

In future releases of Pervasive PSQL 10.x, the core set of CAB files will not change. However, updates to Pervasive PSQL will contain additional CAB files from the original set released in Pervasive PSQL v10 to account for any newly added components or features. Updates to Pervasive PSQL may require generation of additional CAB files, if there are new CAB files present. Be sure and obtain the latest set of files for the installation type and optional features you are installing.

Required Files

CAB files that are required are designated by an underscore. The following table lists the cabinet files required for each installation type.

Table 1-3 Cabinet Files Required by Engine Installation Type
Cabinet File	Server 64	Server 32	Client 64	Client 32	Workgroup
_Client.cab
_Core.cab
_DbEng32.cab
_DbEng64.cab
_DbEng.cab
_PSQL32.cab
_PSQL64.cab
_Srvr32.cab
_Srvr64.cab
_SrvrEng.cab
_WGC.cab
_WGE.cab

Optional Features

The following table lists the optional features by installation type with which they can be applied.

Table 1-4 Optional Features Cabinet Files by Engine Installation Type
Cabinet File	Server 64	Server 32	Client 64	Client 32	Workgroup
ActiveX.cab
ADONet21.cab
ADONet30.cab
BtreveDos.cab
CbolSExe.cab
DDFB.cab
Docs.cab
DTO.cab
EclipRCP.cab
JCL.cab
JDBC.cab
OleDb.cab
PCC.cab
PDAC.cab
PSA.cab
Utils.cab
XIO.cab

Optional Feature Requirements

Certain optional features require that other components accompany them in order to function. The following table lists the optional features that require other components.

Table 1-5 Optional Features Cabinet File Requirements
	Cobol Schema Executor	Data Dictionary File Builder	Pervasive PSQL Control Center	Pervasive System Analyzer	Pervasive User Docs
CbolSExe.cab
DDFB.cab
Docs.cab
EclipRCP.cab
PCC.cab
PSA.cab
Utils.cab

CAB File Installation Example

The following provides an example of customizing your installation using CAB files. This example installs the Workgroup engine with documentation as the only optional feature.

To package a Workgroup Engine with Documentation

Select the required CAB files for the Workgroup Engine (see Cabinet Files Required by Engine Installation Type). These files include the following:

_Core.cab

_DbEng32.cab

_DbEng.cab

_PSQL32.cab

_WGC.cab

_WGE.cab

Select the optional feature CAB files for the documentation (see Optional Features Cabinet File Requirements). These files include the following:

Docs.cab

EclipRCP.cab

The files listed in these two steps are the only CAB files that you need in order to install the Workgroup Engine and documentation. All other CAB files may be removed from the installation package.

Developing an Embedded Installation with Custom File Picking

Another method for embedding the Pervasive PSQL v10 installation with your application is by using custom file picking, which is sometimes referred to as cherry picking. This method allows you to select Pervasive PSQL components at the individual file level.

Before Using Custom File Picking Installation

There are a few considerations to make when using custom file picking for embedding your installation, depending on if you purchase Pervasive PSQL from an OEM or if you are an OEM vendor.

For OEM Customers

It is important to note that installations using custom file picking will not be updated by Pervasive Software updates. If you obtain your Pervasive PSQL from an OEM vendor, you will need to obtain any updates from the OEM vendor as well.

For OEM Vendors

In order to supply updates to your customers, you will need to apply the Pervasive Software updates to your packaged (shrink-wrapped) installation and then go through the custom file picking process again to select which files need to be sent to your customers.

Custom File Picking Prerequisites

In order to use custom file picking you should be aware of the following prerequisites.

Pervasive PSQL v10 core files have a dependency on the Microsoft Visual C++ 8 SP1 Common Runtime being installed. The MS VCRT 8 SP1 should be installed prior to installing Pervasive PSQL. A redistributable installation is available from Microsoft downloads.

The following Pervasive PSQL utilities are dependent on the Java Runtime Environment (JRE) 6 Update 1 from Sun Microsystems:

DDFB32 (DDF Builder)

PCC_32 (PCC)

JDBC32 (Java ODBC)

JCL_32 (JCL)

CRUT32 (Core Utilities

DOCS32 (Documentation)

The JRE can be installed after Pervasive PSQL is installed but must be installed prior to using these utilities. A redistributable installation from Sun can be obtained from the Java website at www.java.com.

Using Custom File Picking

In order to use custom file picking as your embedding method, you must first perform a full install to obtain the individual files and their installed directory locations. Refer to the following tables to determine the applicable installation platforms for each required component and optional feature.

Table 1-6 Required Components by Engine Installation Type
Component	Server 64	Server 32	Client 64	Client 32	Workgroup
Client Specific
Core 32-bit Specific
Core 64-bit Specific
Core Common
DB Engine 32-bit Specific
DB Engine 64-bit Specific
DB Engine Common
RCP Common
Server Engine 32-bit Specific
Server Engine 64-bit Specific
Server Engine Common
WGE/CE Common
WGE Specific

Table 1-7 Optional Features by Engine Installation Type
Component	Server 64	Server 32	Client 64	Client 32	Workgroup
ActiveX Interface Controls
Btrieve DOS
COBOL Schema Executor
Data Access
Data Dictionary File Builder
Documentation
DTO/DTI
Java Class Library
JDBC Driver
ADO.NET Provider 2.1
ADO.NET Provider 3.0
OLE DB
PDAC
Pervasive System Analyzer
Utilities
Pervasive Xtreme I/O

Caution
It is important to note that release and version numbers may vary between Pervasive PSQL components. Major and minor versions within the same release should always be the same.

Component and Feature Files

The following tables list the files and associated language dependencies for each of the required components and optional features you can select for an embedded installation using custom file picking.

Client Specific

The following details the Client Specific required feature. This component is hidden in the list of features displayed in the user interface.

Table 1-8 Client Specific Feature Files
File Name	Language
w3cache.dll	Language Independent

Core Common

The following details the Core Common required feature. This component is hidden in the list of features displayed in the user interface.

Table 1-9 Core Common Feature Files
File Name	Language
bdu.exe	Language Independent
bdulb.dll	Language Independent
bdumsgrb.dll4	Language Independent
clientrb.dll4	Language Independent
collate.cfg (Not installed on Client 32-bit)	Language Independent
dbcsipxy.dll4	Language Independent
idshosts	Language Independent
licmgrrb.dll4	Language Independent
mfc80.dll	English (United States)
MFC80ENU.dll	English (United States)
MFC80JPN.dll	Japanese
mfc80u.dll	English (United States)
mfcm80.dll	English (United States)
mfcm80u.dll	English (United States)
mkc3.dll4	Language Independent
mkderb.dll4	Language Independent
msvcm80.dll	English (United States)
msvcp80.dll	English (United States)
msvcr80.dll	English (United States)
pceurop.dll4	Language Independent
pctlgrb.dll4	Language Independent
pscl3.dll	Language Independent
pscore3.dll	Language Independent
pscp932.dll4	Language Independent
pvddl.exe	Language Independent
pvmsgrb.dll4	Language Independent
pvsw.log	Language Independent
upiapirb.dll4	Language Independent
w32btxlt.dll	Language Independent
w3btrv7.dll	Language Independent
w3clnres.dll	Language Independent
w3clnrsx.dll	Language Independent
w3csi100.dll4	Language Independent
w3csm100.dll4	Language Independent
w3csp100.dll4	Language Independent
w3dbav75.dll	Language Independent
w3dbav78.dll	Language Independent
w3dbav80.dll	Language Independent
w3dbav90.dll	Language Independent
w3dcm100.dll4	Language Independent
w3lgo103.exe	Language Independent
w3mif190.dll	Language Independent
w3mpm100.dll4	Language Independent
w3odbcci.dll	Language Independent
w3odbccs.dll	Language Independent
w3upi310.dll	Language Independent
wbtrv32.dll	Language Independent
wdbuui32.dll	English (United States)
wdbuui32.dll	Japanese
4The files with this indication must be registered. See Registering Component Files for more information.

Core 32-bit Specific

The following details the Core 32-bit Specific required feature. This component is hidden in the list of features displayed in the user interface.

Table 1-10 Core 32-bit Specific Feature Files
File Name	Language
PSQL_v10_Client_x64_Manifest.csv1
PSQL_v10_Client_x86_Manifest.csv1
PSQL_v10_Server_x64_Manifest.csv1
PSQL_v10_Server_x86_Manifest.csv1
PSQL_v10_WGE_x86_Manifest.csv1
pvisr.dll2	Language Independent
1These files are conditioned so that only one is installed, depending on the installation type (Client 32-bit/64-bit, Server 32-bit/64-bit, or Workgroup). 2This file is conditioned to not install during a Client 64-bit or Server 64-bit install.

Core 64-bit Specific

The following details the Core 64-bit Specific required feature. This component is hidden in the list of features displayed in the user interface

Table 1-11 Core 64-bit Specific Feature Files
File Name	Language
mfc80.dll	English (United States)
MFC80ENU.dll	English (United States)
MFC80JPN.dll	Japanese
mfc80u.dll	English (United States)
mfcm80.dll	English (United States)
mfcm80u.dll	English (United States)
msvcm80.dll	English (United States)
msvcp80.dll	English (United States)
msvcr80.dll	English (United States)
w64btrv.dll	Language Independent
w64clientrb.dll4	Language Independent
w64csm.dll4	Language Independent
w64csp.dll4	Language Independent
w64dba.dll	Language Independent
w64dbcsipxy.dll4	Language Independent
w64dcm.dll4	Language Independent
w64licmgrrb.dll4 (Not installed on Client 64-bit)	Language Independent
w64mif.dll	Language Independent
w64mkderb.dll4 (Not installed on Client 64-bit)	Language Independent
w64nsl.dll	Language Independent
w64pceurop.dll	Language Independent
w64pctlgrb.dll4	Language Independent
w64pscl3.dll	Language Independent
w64pscore3.dll	Language Independent
w64pscp932.dll	Language Independent
w64pvisr.dll (Not installed on Client 64-bit)	Language Independent
w64upi.dll	Language Independent
w64upiapirb.dll4	Language Independent
4The files with this indication must be registered. See Registering Component Files for more information.

DB Engine 32-bit Specific

The following details the DB Engine 32-bit Specific required feature. This component is hidden in the list of features displayed in the user interface.

Table 1-12 DB Engine 32-bit Specific Feature Files
File Name	Language
clilcadm.exe	Language Independent
enginelm.dll	Language Independent
legacylm.dll	Language Independent
mkdemd.dll	Language Independent
w3comsrv.dll	Language Independent
w3exp010.dll	Language Independent

Server Engine 64-bit Specific

The following details the Server Engine 64-bit Specific required feature. This component is hidden in the list of features displayed in the user interface.

Table 1-13 Server Engine 64-bit Specific Feature Files
File Name	Language
ntdbsmgr64.exe	Language Independent
w64clilcadm.exe	Language Independent
w64comsrv.dll	Language Independent
w64enginelm.dll	Language Independent
w64exp010.dll4	Language Independent
w64legacylm.dll4	Language Independent
w64mkdemd.dll	Language Independent
w64ntmkde.dll	Language Independent
4The files with this indication must be registered. See Registering Component Files for more information.

DB Engine 64-bit Specific

The following details the DB Engine 64-bit Specific required feature. This component is hidden in the list of features displayed in the user interface.

Table 1-14 DB Engine 64-bit Specific Feature Files
File Name	Language
w64csi.dll4	Language Independent
w64mkc3.dll4	Language Independent
w64mpm.dll4	Language Independent
4The files with this indication must be registered. See Registering Component Files for more information.

DB Engine Common

The following details the DB Engine Common required feature. This component is hidden in the list of features displayed in the user interface.

Table 1-15 DB Engine Common Feature Files
File Name	Language
allprocsproc.sql	Language Independent
billing.sdf	Language Independent
class.sdf	Language Independent
course.sdf	Language Independent
demodata.sql	Language Independent
dept.sdf	Language Independent
email.htm	English (United States)
email.htm	Japanese
enrolls.sdf	Language Independent
faculty.sdf	Language Independent
person.sdf	Language Independent
psp_column_attributes.sql	Language Independent
psp_column_rights.sql	Language Independent
psp_columns.sql	Language Independent
psp_database_version.sql	Language Independent
psp_fkeys.sql	Language Independent
psp_groups.sql	Language Independent
psp_help_sp.sql	Language Independent
psp_help_trigger.sql	Language Independent
psp_help_udf.sql	Language Independent
psp_help_view.sql	Language Independent
psp_indexes.sql	Language Independent
psp_pkeys.sql	Language Independent
psp_procedure_rights.sql	Language Independent
psp_rename.sql	Language Independent
psp_stored_procedures.sql	Language Independent
psp_table_rights.sql	Language Independent
psp_tables.sql	Language Independent
psp_triggers.sql	Language Independent
psp_udfs.sql	Language Independent
psp_users.sql	Language Independent
psp_view_rights.sql	Language Independent
psp_views.sql	Language Independent
reg-foot.jpg	English (United States)
reg-foot.jpg	Japanese
reg-head.jpg	English (United States)
reg-head.jpg	Japanese
register.htm	English (United States)
register.htm	Japanese
room.sdf	Language Independent
rsiddf.dll	Language Independent
sample.btr	Language Independent
setupdb.exe	Language Independent
student.sdf	Language Independent
tuition.sdf	Language Independent
upper.alt	Language Independent
w32setupdb.cfg	Language Independent
w3mgrmsg.dll	Language Independent
w3mgrres.dll	Language Independent
w3mgrrsx.dll	Language Independent
w3odbcei.dll	Language Independent
w3odbces.dll	Language Independent
w3sqlmgr.dll	Language Independent
w3xlt101.dll	Language Independent

Server Engine 32-bit Specific

The following details the Server Engine 32-bit Specific required feature. This component is hidden in the list of features displayed in the user interface.

Table 1-16 Server Engine 32-bit Specific Feature Files
File Name	Language
ntmkde.dll	Language Independent

Server Engine Common

The following details the Server Engine Common required feature. This component is hidden in the list of features displayed in the user interface.

Table 1-17 Server Engine Common Feature Files
File Name	Language
ntbtrv.exe	Language Independent
ntdbsmgr.exe	Language Independent
w3sqlmgr.exe	Language Independent

WGE/CE Common

The following details the WGE/CE Common required feature. This component is hidden in the list of features displayed in the user interface.

Table 1-18 Workgroup Engine/Client Engine Common Feature Files
File Name	Language
w3dbsmgr.exe 3 (WGE or CE installed to run as a service under the local system account)	Language Independent
w3dbsmgr.exe3 (CE installed to run as an application)	Language Independent
w3dbsmgr.exe3 (WGE installed to run as an application)	Language Independent
w3dbsmgr.exe3 (WGE or CE installed to run as a service under specific user account)	Language Independent
3The files in this component are conditioned to be mutually exclusive (only one can be installed at a time) and correspond to conditions listed with the file name.

WGE Specific

The following details the WGE Specific required feature. This component is hidden in the list of features displayed in the user interface.

Table 1-19 Workgroup Engine Specific Feature Files
File Name	Language
pvkillwg.exe	English (United States)
pvkillwg.exe	Japanese
pvlocate.exe	Language Independent
w3mkde.dll	Language Independent

Pervasive Xtreme I/O

The following details the Xtreme I/O feature. This component requires disabling the Windows Large System Cache and the Pervasive PSQL MKDE L2 Cache settings in the system registry.

Table 1-20 Pervasive PSQL Xtreme I/O Feature Files
File Name	Language
XioCache.sys	Language Independent
XioDf.sys	Language Independent
xioexclude.lst	Language Independent
Xiofsf.sys	Language Independent
XioIfc.dll	Language Independent
xiomgr.exe	Language Independent
XioStats.exe	Language Independent

Documentation

The following details the Pervasive PSQL Engine and SDK User Documentation feature.

Table 1-21 Documentation
File Name	Language
ATTRIB.DDF	Language Independent
com.pervasive.help.docs.psql.enus_1.0.0.jar	English (United States)
com.pervasive.help.docs.psql.jajp_1.0.0.jar	Japanese
CREATE_NEW.MKD	Language Independent
CUST	Language Independent
CUST.DTA	Language Independent
CUST2.DTA	Language Independent
CUSTOMER.DTA	Language Independent
email.htm	English (United States)
email.htm	Japanese
FIELD.DDF	Language Independent
FILE.DDF	Language Independent
FLAGS.MKD	Language Independent
helpviewer.gif	Language Independent
helpviewer.ico	Language Independent
INDEX.DDF	Language Independent
INDEX_INC.MKD	Language Independent
INVOICE.DTA	Language Independent
jh.jar	Language Independent
keyhh.exe	Language Independent
KO.btr	Language Independent
KO.mkd	Language Independent
mail.htm	English (United States)
mail.htm	Japanese
OCCURS.DDF	Language Independent
OVERLAP.MKD	Language Independent
plugin.xml	Language Independent
preferences.ini	Language Independent
PROC.DDF	Language Independent
pvswdocs.bat	Language Independent
pvswdocs.chm	English (United States)
pvswhelpui.jar	Language Independent
readme.htm	English (United States)
readme.htm	Japanese
readme_activex.htm	English (United States)
readme_activex.html	Japanese
readme_adonet.htm	English (United States)
readme_adonet.html	Japanese
readme_btrieve.htm	English (United States)
readme_btrieveapi.html	Japanese
readme_ddfbldr.htm	English (United States)
readme_ddfbldr.htm	Japanese
readme_dti.htm	English (United States)
readme_dti.html	Japanese
readme_dto.htm	English (United States)
readme_dto.html	Japanese
readme_jcl.htm	English (United States)
readme_jcl.html	Japanese
readme_jdbc.htm	English (United States)
readme_jdbc.html	Japanese
readme_oledb.htm	English (United States)
readme_oledb.html	Japanese
readme_pdac.htm	English (United States)
readme_pdac.html	Japanese
readsdk.htm	English (United States)
readsdk.htm	Japanese
REC_LENGTH.MKD	Language Independent
reg-foot.jpg	English (United States)
reg-foot.jpg	Japanese
reg-head.jpg	English (United States)
reg-head.jpg	Japanese
RELATE.DDF	Language Independent
RIGHTS.DDF	Language Independent
TRIGGER.DDF	Language Independent
TYPE_SIZE.MKD	Language Independent
USER.DDF	Language Independent
utilsgde.chm	English (United States)
utilsgde.chm	Japanese
VARIANT.DDF	Language Independent
VARTABLE.MKD	Language Independent
VIEW.DDF	Language Independent

Data Access

The following details the Pervasive PSQL SDK Data Access common run time features.

ActiveX Interface Controls

The following details the set of custom controls that support accessing Btrieve data from development environments that support ActiveX.

Table 1-22 ActiveX Interface Controls
File Name	Language
ACBtr732.ocx	English (United States)
Acctr732.ocx	English (United States)
PBtrvD32.dll	English (United States)
Pedtconv.dll	English (United States)
vaccess4.lic	Language Independent

Btrieve DOS

The following details the Pervasive BTRBOX for DOS application feature.

Table 1-23 Btrieve DOS
File Name	Language
BTRDRVR.SYS	English (United States)
BTRDRVR.SYS	Japanese
BTRVDD.DLL	English (United States)
BTRVDD.DLL	Japanese

DTO/DTI

The following details the Pervasive Distributed Tuning Objects (DTO) and Distributed Tuning Interface (DTI) for visual development environments feature.

Table 1-24 DTO/DTI
File Name	Language
dto.dll	Language Independent
dto2.dll	Language Independent

Java Class Library

The following details the Java Class Library set used for access to Btrieve data feature.

Table 1-25 Java Class Library
File Name	Language
jnibtrv.dll	Language Independent
psql.jar	Language Independent

JDBC Driver

The following details the JDBC driver used to access tabular data sources from the Java programming language feature.

Table 1-26 JDBC Driver
File Name	Language
jpscs.jar	Language Independent
pvjdbc2.dll	Language Independent
pvjdbc2.jar	Language Independent
pvjdbc2x.jar	Language Independent

ADO.NET Provider 2.1

The following details the Pervasive PSQL ADO.NET 2.1 data provider for running and connecting to a database using ADO.NET Version 1.0 (NET Framework Version 1.x) common interfaces and factories feature.

Table 1-27 ADO.NET Provider 2.1
File Name	Language
Pervasive.Data.SqlClient.dll	Language Independent
Pervasive.Data.SqlClient.xml	English (United States)
Pervasive.Data.SqlClient.xml	Japanese

ADO.NET Provider 3.0

The following details the Pervasive PSQL ADO.NET 3.0 data provider for running and connecting to a database using ADO.NET Version 2.0 (NET Framework Version 2.x) common interfaces and factories feature.

Table 1-28 ADO.NET Provider 3.0
File Name	Language
Pervasive.Data.SqlClient.dll	Language Independent
Pervasive.Data.SqlClient.xml	English (United States)
Pervasive.Data.SqlClient.xml	Japanese

OLE DB

The following details the OLE DB runtime binaries for providing various types of data access feature.

Table 1-29 OLE DB
File Name	Language
poledb.dll4	Language Independent
poledber.dll4	Language Independent
poledbsy.dll4	Language Independent