Checking SQLCE version

[AMI]

I'm building a bootstrapper that makes sure that my PocketPC device is at
the correct patch level for all components (like SQLCE), and I'm wondering
if there is any way to programatically determine the exact version of SQLCE
that I have installed.

I've found one posting that recommends reading the registry to verify that:

HKLM\Software\Apps\Microsoft SQLCE 2.0\Instl = 1

..... but this wouldn't tell the exact version and hence wouldn't really help
me ensure its patch level going forward.

I'm aware of the ssce20 and ssce20 files in the Windows\SQLCE 2.0 directory,
but I have not found a way to query those files for a version number.

Thank you for any input.

 

[John Kendrick]

Try looking for key, [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SQLCE 2.0].
This should give you the Major, Minor and Build numbers.

 

[AMI]

Bingo, thanks John.

Try looking for key, [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SQLCE 2.0].
This should give you the Major, Minor and Build numbers.

I'm building a bootstrapper that makes sure that my PocketPC device is at
the correct patch level for all components (like SQLCE), and I'm wondering
if there is any way to programatically determine the exact version of SQLCE
that I have installed.

I've found one posting that recommends reading the registry to verify that:

HKLM\Software\Apps\Microsoft SQLCE 2.0\Instl = 1

.... but this wouldn't tell the exact version and hence wouldn't really