Microsoft KB Archive/945317

= You encounter various problems after you install SQL Server Compact 3.5 on a computer that has SQL Server Compact 3.5 Beta installed =

Article ID: 945317

Article Last Modified on 12/28/2007

-

APPLIES TO


 * Microsoft SQL Server Compact 3.5

-



Symptom 1
You have a computer that has Microsoft SQL Server Compact 3.5 Beta installed. You also install Visual Studio 2008. When you try to connect to a database of SQL Server Compact 3.5 Beta in Server Explorer, Visual Studio 2008 crashes. Even after you repair Visual Studio 2008, you still encounter this problem. See Workaround 2 in the &quot;Workaround&quot; section.

Note In Windows XP or in Windows Server 2003, you repair Visual Studio 2008 in the Add or Remove Programs item in Control Panel. In Windows Vista, you repair Visual Studio 2008 in the Programs and Features item.

Symptom 2
You have a computer that has SQL Server Compact 3.5 Beta installed. When you try to deploy Microsoft SQL Server Compact 3.5 on the computer by using ClickOnce technology, the ClickOnce application may not work correctly. See Workaround 1 in the &quot;Workaround&quot; section.

Symptom 3
You upgrade SQL Server Compact 3.5 Beta to SQL Server Compact 3.5. The database files of SQL Server Compact 3.5 display a general purpose Windows icon. However, you expect that the database files display the SQL Server Compact 3.5 icon. See Workaround 2 in the &quot;Workaround&quot; section.

Note SQL Server Compact 3.5 is also included with Visual Studio 2008.



CAUSE
These problems occur because of a bug in the Microsoft Windows Installer (.msi) package for SQL Server Compact 3.5.



Workaround 1
To work around this problem, uninstall SQL Server Compact 3.5 Beta.

Workaround 2
To work around this problem, follow these steps:  Uninstall SQL Server Compact 3.5 Beta. Repair the current installation of SQL Server Compact 3.5. To do this, use the appropriate step:  In Windows XP or in Windows Server 2003, follow these steps:  In Control Panel, double-click Add or Remove Programs. Under Currently installed programs, click Microsoft SQL Server Compact 3.5, click Click here for support information, and then click Repair.  To do this in Windows Vista, follow these steps:  In Control Panel, double-click Programs and Features.</li> Click Microsoft SQL Server Compact 3.5, and then click Repair.</li></ol> </li></ul> </li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
When you repair Visual Studio 2008, the Visual Studio 2008 Setup program does not install SQL Server Compact 3.5 and SQL Server Compact 3.5 Design Tools if SQL Server Compact 3.5 and SQL Server Compact 3.5 Design Tools are not already installed. If SQL Server Compact 3.5 and SQL Server Compact 3.5 Design Tools are already installed, the Visual Studio 2008 Setup program repairs SQL Server Compact 3.5 and SQL Server Compact 3.5 Design Tools when you repair Visual Studio 2008. Therefore, if you have SQL Server Compact 3.5 Beta installed before you install Visual Studio 2008, the Visual Studio 2008 Setup program does not install SQL Server Compact 3.5. You must manually uninstall SQL Server Compact 3.5 Beta and SQL Server Compact 3.5 Design Tools Beta, and then you must install SQL Server Compact 3.5 and SQL Server Compact 3.5 Design Tools.

The Windows Installer packages for SQL Server Compact 3.5 and for SQL Server Compact 3.5 Design Tools are located in the following folder on the Visual Studio 2008 installation media:

WCU\SSCE

The file name of the SQL Server Compact 3.5 package is SSCERuntime- .msi.

The file name of the SQL Server Compact 3.5 Design Tools package is SSCEVSTools- .msi.

Note  represents the product language.

When you install SQL Server Compact 3.5, the Windows Installer package is supposed to uninstall the earlier version of SQL Server Compact 3.5 first. Then, Windows Installer installs SQL Server Compact 3.5. However, because the Windows Installer package for SQL Server Compact 3.5 contains a bug, you must manually uninstall SQL Server Compact 3.5 Beta first. Then, you can install SQL Server Compact 3.5.

<div class="moreinformation_section">

Additionally, you cannot install SQL Server Compact 3.5 Beta on a computer that has SQL Server Compact 3.5 installed.

This behavior is also true for the following products:
 * SQL Server Compact 3.5 Beta
 * SQL Server Compact 3.5
 * SQL Server Compact 3.5 SP1 Beta
 * SQL Server Compact 3.5 for Devices Beta
 * SQL Server Compact 3.5 for Device
 * SQL Server Compact 3.5 SP1 for Devices Beta
 * SQL Server Compact 3.5 Design Tools Beta
 * SQL Server Compact 3.5 Design Tools
 * SQL Server Compact 3.5 Server Tools Beta
 * SQL Server Compact 3.5 Server Tools
 * SQL Server Compact 3.5 SP1 Management Tools Beta

SQL Server Compact 3.5 SP1 Management Tools Beta is included in Microsoft SQL Server 2008 Community Technology Preview (CTP). SQL Server Compact 3.5 Design Tools Beta is included only in Visual Studio 2008 Beta. SQL Server Compact 3.5 Design Tools is included only in Visual Studio 2008.

<div class="moreinformation_section">

Additionally, you cannot repair SQL Server Compact 3.5 Design Tools. You must uninstall and then reinstall SQL Server Compact 3.5 Design Tools.

Keywords: kbexpertiseadvanced kbtshoot kbprb KB945317

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.