Click Here to Install Silverlight*
United StatesChange|All Microsoft Sites
Microsoft
Download Center 
Search Advanced Search

Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit

Brief Description
SQL Server 2005 Compact Edition Developer SDK contains the files required for installing SQL Server 2005 Compact Edition on mobile devices, desktop and tablet PC. It also has the Help File, and the Header files for native development, and the Northwind sample application.

On This Page

Quick Details
File Name:SSCE31SDK-ENU.msi
Version:1.0
Knowledge Base (KB) Articles:KB920700
Date Published:1/11/2007
Language:English
Download Size:36.5 MB
Estimated Download Time: 1 hr 29 min 56K
Change Language:
  

Overview

Microsoft SQL Server 2005 Compact Edition (SQL Server 2005 Compact Edition) is designed for developers who need light weight, in process relational database solution for their applications that can be developed and deployed on desktop, tablet PC and mobile devices. SQL Server 2005 Compact Edition Developer SDK contains the following for developing applications with SQL Server 2005 Compact Edition as a database store for the applications:

  • CAB files for installing SQL Server 2005 Compact on mobile devices
  • MSI file for installing SQL Server 2005 Compact Edition on desktop and tablet PC
  • Header files required for developing a native SQL Server Compact application
  • MSI for installing the SQL Server 2005 Compact Edition Help Files
  • Northwind sample application

The English version of SQL Server Compact Edition Developer SDK contains only the English version of SQL Server Compact Edition Runtime. The localized version of SQL Server Compact Edition Developer SDK contains the English version of SQL Server Compact Edition Runtime and the localized version SQL Server Compact Edition Runtime. After you install SQL Server Compact Edition Developer SDK, the installer package for SQL Server Compact Edition Runtime is located in the following folder: %programfiles%\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\Desktop To install the localized version of SQL Server 2005 Compact Edition Runtime from the localized version of SQL Server 2005 Compact Edition Developer SDK, follow these steps:
  • Open the following folder: %programfiles%\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\Desktop
  • Install the English version of SQL Server Compact Edition Runtime (SQLServerCE31-EN.msi).
  • Install the localized version of SQL Server Compact Edition Runtime (SQLServerCE31-[LN].msi)

 Top of page

System Requirements

  • Supported Operating Systems: Windows 2000 Service Pack 4; Windows CE; Windows Mobile 2003 software for Pocket PCs; Windows Mobile 5.0; Windows Server 2003 R2 (32-Bit x86); Windows Server 2003 R2 Datacenter Edition (32-Bit x86); Windows Server 2003 R2 Enterprise Edition (32-Bit x86); Windows Server 2003 R2 Standard Edition (32-bit x86); Windows Server 2003, Datacenter Edition (32-bit x86); Windows Server 2003, Standard Edition (32-bit x86); Windows XP Home Edition ; Windows XP Media Center Edition; Windows XP Professional Edition ; Windows XP Service Pack 2; Windows XP Tablet PC Edition

Development Computer
  • 38 MB of available hard disk space. (An additional 38 MB of space must be also available for temporary setup files.)

  • Microsoft Internet Explorer 6.0 or later

  • Active Sync 4.0 or later

  • Visual Studio 2005


Mobile Devices
  • Any device that runs Microsoft Windows CE 5.0, Windows Mobile 2003 Software for Pocket PC, or Windows Mobile 5.0

  • 2–3 MB of available storage space, depending on processor type, operating system version, and components installed.


Desktop and Tablet PC
  • Windows XP Professional SP2, Windows XP Home Edition SP2, Windows XP Media Center Edition 2002 SP2, Windows XP Media Center Edition 2004 SP2, Windows XP Media Center Edition 2005, Windows XP Tablet PC Edition SP2, Windows Server 2003, Standard Edition SP1, Windows Server 2003, Enterprise Edition SP1, Windows Server 2003, Datacenter Edition SP1, Windows Server 2003 R2, Standard Edition, Windows Server 2003 R2, Enterprise Edition, Windows Server 2003 R2, Datacenter Edition, Windows Server 2000 Professional SP4, Windows Server 2000 Server SP4

  • 2–3 MB of available storage space, depending on processor type, operating system version, and components installed.


For Merge Replication and Remote Data Access (RDA)
  • SQL Server 2000 with Service Pack 3a or higher

  • IIS 5.0 or later versions: Supported on Windows Server 2003, Windows 2000 SP4 or later versions, and Windows XP; 120 MB of available disk space on the server

 Top of page

Instructions

  1. Click the Download button on this page to start the download, or choose a different language from the drop-down list and click Go.
  2. Do one of the following:
    • To start the installation immediately, click Open or Run this program from its current location.
    • To copy the download to your computer for installation at a later time, click Save or Save this program to disk.

 Top of page

Additional Information

SQL Server 2005 Compact Edition runtime for desktop and tablet PC, includes a Microsoft Windows Installer (.msi) file. The .msi file installs redistributable components to a specific location on the destination computer. To ensure serviceability and technical support, use the .msi file to deliver software components. Please see Redist.txt included in the package for component information.

SQL Server 2005 Compact Edition can be installed by running the installer - SQLServerCE31-EN.msi. Installing SQL Server 2005 Compact Edition by running SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll). Doing this ensures that the components can be serviced in future by Microsoft Update. Administrator privileges are required on the machine for installing SQL Server 2005 Compact Edition. Independent Software Vendors and application developers redistributing SQL Server 2005 Compact Edition components or DLL’s as part of their application will need to take care of the serviceability of SQL Server 2005 Compact Edition components. Microsoft Update can only service SQL Server 2005 Compact Edition components that are deployed by using the installer - SQLServerCE31-EN.msi.

 Top of page

 Top of page

 Top of page

© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use |Trademarks |Privacy Statement