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 translations Article translations
Article ID: 945317 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

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 "Workaround" 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 "Workaround" 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 "Workaround" 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

Workaround 1

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

Workaround 2

To work around this problem, follow these steps:
  1. Uninstall SQL Server Compact 3.5 Beta.
  2. 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:
      1. In Control Panel, double-click Add or Remove Programs.
      2. 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:
      1. In Control Panel, double-click Programs and Features.
      2. Click Microsoft SQL Server Compact 3.5, and then click Repair.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" 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-Language.msi.
The file name of the SQL Server Compact 3.5 Design Tools package is SSCEVSTools-Language.msi.

Note Language 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.
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.
Additionally, you cannot repair SQL Server Compact 3.5 Design Tools. You must uninstall and then reinstall SQL Server Compact 3.5 Design Tools.

Properties

Article ID: 945317 - Last Review: December 28, 2007 - Revision: 3.1
APPLIES TO
  • Microsoft SQL Server Compact 3.5
Keywords: 
kbexpertiseadvanced kbtshoot kbprb KB945317

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com