Click here to Skip to main content
Click here to Skip to main content

Reading Data from MSI Database

, 29 Apr 2003
Rate this:
Please Sign up or sign in to vote.
A console application to read data from a Windows Installer database

Introduction

I was in need of reading data from an .msi file and after reading a nice article in the form of a pdf file, I made a simple console application that takse 2 command line arguments (first is full path to .msi file second one is the table name). I prefered doing a console application because it will be useful to all even having MFC or windows knowledge.

Background

Last week I installed InstallShield for Windows Installer 1.5 on my system and some how I learned how to create an .msi setup file. I was in need of it as we planned to port the tool on which I'm working to the newer version of InstallShield. I searched for help but finally helped myself to learn how to create msi files with InstallShield. I wouldn't say I mastered InstallShield but I can say I know little bit of InstallShield.

Actually the tool for which I have been working on needs the details of .msi files to create MOF files, so I was trying to read the .msi database (.msi is a setup file implemented as a database by Microsoft and it is run by Windows Installer, a service which runs in Windows 2000 and Windows XP).

Using the Code

First location I refered is MSDN. It says what are the functions we have to manipulate a .msi database. But as my attempt to work myself with the MSDN help to read .msi databse didn't work. So I searched on net. and I got nic pdf file regarding this pdf file http://www.wise.com/filelib/MSIwhitepaper.pdf. Please read the article for a full description on "how to". I used the code help from this article only. The flow goes like this. First we have to start with MsiOpenDatabase(..) which gives a MSIHANDLE after successful opening of the msi database. Then I called MsiDatabaseOpenView(hDatabase,szSelect,&hView) where hDatabase is the handle got from MsiOpenDatabase(). szSelect is a normal SQL query, then hView is the MSIHANDLE returned by this function on success. This function when called creates a view with the given query. To get the actual records we have to call MsiViewExecute(), which gives the perfectness to the view(means practically this function executes the query and stores the result in the view) Then remaining part of the code is parsing the data and printing on the screen. I once again repeat the pdf I read is the source for my application. I thank "Gary Chirhart" for writing such a nice article on Installer. my application takes 2 command line arguments( other than application name)

  1. msi file path: rememeber to give the path with "\\" separation like D:\\Share\\VMTNet.msi
  2. A table name existing in .msi database. There are so many tables but I prefer to give "File" as 2nd parameter.This table contains all the details embedded files in the .msi database.

For better understanding of the database structure one can use "ORCA" tool.

Points of Interest

The interesting thing I learned is actually we don't need any third party tools like Installshield or wise Installer to create .msi setup files. Everything can be done by us The only thing the third party vendors are doing is making things simple so that we can concentrate on development of our software so that we need not worry much about creating installers to our software.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

harinath
Architect Careerscale IT Consulting LLP
India India
Hi, all
 
I have been working on java/j2EE technologies, and some time back in Microsoft technologies.
 

Harinath Mallepally,
Careerscale IT Consulting LLP
http://careerscale.in
Hyderabad
India

Comments and Discussions

 
Generalthank you. Pinmembersanji200916-Apr-10 0:56 
GeneralGood info! PinmemberPortatofe2-Oct-08 7:02 
GeneralNeed examples Pinmemberz8871209-Aug-07 23:48 
GeneralThanks for a useful link PinmemberTroubleSolver20-Nov-05 14:26 
GeneralGood work Pinmemberjosephjk16-Sep-03 7:43 
QuestionVBScript anyone? PinmemberMike Klimentiev6-May-03 9:15 
AnswerRe: VBScript anyone? Pinmemberharinath6-May-03 18:29 
AnswerRe: VBScript anyone? PinmemberBlueLoveCyn18-Jul-06 18:25 
AnswerRe: VBScript anyone? PinmemberMike Klimentiev19-Jul-06 9:50 
GeneralNo Knowledge of Windows Installer PineditorHeath Stewart30-Apr-03 18:45 
GeneralRe: No Knowledge of Windows Installer Pinmemberharinath1-May-03 0:27 
GeneralRe: No Knowledge of Windows Installer PineditorHeath Stewart1-May-03 3:40 
GeneralRe: No Knowledge of Windows Installer Pinmemberharinath1-May-03 3:55 
GeneralRe: No Knowledge of Windows Installer PinsussAnonymous6-May-03 12:59 
GeneralRe: No Knowledge of Windows Installer Pinmemberharinath6-May-03 18:34 
GeneralRe: No Knowledge of Windows Installer PinsussAnonymous26-Apr-05 6:00 
GeneralRe: No Knowledge of Windows Installer PinmemberTroubleSolver20-Nov-05 14:23 
GeneralRe: No Knowledge of Windows Installer Pinmemberjbalaji8421-Dec-06 20:52 
GeneralRe: No Knowledge of Windows Installer Pinsusstom Stratemeyer15-Dec-03 15:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.141220.1 | Last Updated 30 Apr 2003
Article Copyright 2003 by harinath
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid