A Database and Patch Example

Windows Installer

A Database and Patch Example

An application can use the MsiOpenDatabase function to open a new or existing installation database (.msi file) or patch package (.msp file.) The application checks the return value of MsiOpenDatabase before using the database handle.

The following examples use the PMSIHANDLE type variables defined in msi.h. It is recommended to use the PMSIHANDLE type because the installer closes PMSIHANDLE objects as they go out of scope, whereas your application must close MSIHANDLE objects by calling MsiCloseHandle. For more information see Use PMSIHANDLE instead of HANDLE section in the Windows Installer Best Practices.

The following example opens a database, sample.msi, for reading only. MsiOpenDatabase succeeds only if sample.msi exists in the c:\test directory. Upon success, the returned database handle can be used to query the data in the installation package using MsiDatabaseOpenView and MsiGetSummaryInformation.

PMSIHANDLE hDbReadOnly = 0;
UINT uiStatus1 = MsiOpenDatabase(TEXT("c:\\test\\sample.msi"), MSIDBOPEN_READONLY, &hDbReadOnly);
if (ERROR_SUCCESS != uiStatus1)
{
	// process error
	return uiStatus1;
}

The following example opens the database for reading and writing. If the application calls MsiDatabaseCommit, all changes made to the database are saved. If the application does not call MsiDatabaseCommit, no changes are made to the database.

PMSIHANDLE hDbTransact = 0;
UINT uiStatus2 = MsiOpenDatabase(TEXT("c:\\test\\example.msi"), MSIDBOPEN_TRANSACT, &hDbTransact);
if (ERROR_SUCCESS != uiStatus2)
{
	// process error
	return uiStatus2;
}

The following example takes an existing database, text.msi, and creates a new database, newtest.msi. Any changes that are made can be saved in the new database by calling MsiDatabaseCommit. The existing database specified in the szDatabasePath parameter is unchanged.

PMSIHANDLE hDbOutput = 0;
UINT uiStatus3 = MsiOpenDatabase(TEXT("c:\\test\\test.msi"), TEXT("c:\\test\\newtest.msi"), &hDbOutput);
if (ERROR_SUCCESS != uiStatus3)
{
	// process error
	return uiStatus3;
}

The following example opens a Windows Installer patch package (.msp file) for reading only. The returned patch handle can be used to determine the cabinets and transform substorages included in the patch package by queries on the _Streams and _Storages tables.

Windows Installer 2.0:  Not supported. Beginning with Windows Installer 3.0, the application can query the MsiPatchSequence table present in a patch package that uses the new patch sequencing information.

PMSIHANDLE hDbPatch = 0;
LPCTSTR szPersistMode = MSIDBOPEN_READONLY + MSIDBOPEN_PATCHFILE;
UINT uiStatus4 = MsiOpenDatabase(TEXT("c:\\test\\sample.msp"), szPersistMode, &hDbPatch);
if (ERROR_SUCCESS != uiStatus4)
{
	// process error
	return uiStatus4;
}

Send comments about this topic to Microsoft

Build date: 8/13/2009

© 2009 Microsoft Corporation. All rights reserved.