I created a 32 bit installer that uses SqlServerCe 3.5 (32 bit version). The install works perfectly on Windows 7 Home and Windows 8. When I try to install it on Windows 7 Professional 32 bit I get the following warning: "WARNING - On a 64-bit Comuter, install both 32-bit and 64-bit versions of the SQL Server Compact 3.5 SP2 MSI files. Existing SQL Server Compact 3.5 applications will fail if only the 32-bit version is installed on the 64-bit computer. Developers should chain both the 32-bit and the 64-bit MSI files with their applications and install both of them on the 64-bit computer. See install.txt file for more information. Click "Yes" to continue."
Yet I am installing on a 32bit computer. Then I get the following warning: Warning 4154.SQL Server Compact 3.5 SP2 prerequisite was not correctly installed.
and then the program does not run. Not sure why Advanced Installer thinks my 32bit version of Windows is 64 bit.