devbuzz
Posts: 447
Score: 0
Joined: 4/26/2002
From: New Jersey, USA & Cape Town, SA
Status: offline
|
Here is a summary of the notes I made when working out what tools were needed to support developing SQL Server 2005 Compact Edition applications using Visual Studi 2005.
A good background read: An introduction to SQL Server 2005 Compact Edition
This is the order you should install the tools:
1) Install Microsoft SQL Server 2005 Compact Edition
Microsoft SQL Server 2005 Compact Edition is the compact database for rapidly developing applications in both native and managed environment that extend enterprise data management capabilities to desktop applications.
Download: SQLServerCE31-EN.msi
2) Install Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit
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.
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
Download: SSCE31SDK-ENU.msi
3) Install Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 Service Pack 1
The download is installed after the installation of Visual Studio 2005 SP1 and updates the Smart Device Development components in Visual Studio 2005 SP1 with the SQL Server 2005 Compact Edition design time UI/Dialogs, device CAB files, and includes new features like Click Once support.
Download: SSCE31VSTools-ENU.exe
4) Install SQL Server 2005 Compact Edition (SSCE) Books Online (March 2007)
Download: SSCE31BOL-ENU.msi
5) Install Microsoft SQL Server 2005 Mobile Edition Server Tools
If you have already installed the SDK you can find it here:
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\Sqlce30setupen.msi
Microsoft SQL Server 2005 Mobile Edition Server Tools updates the servers running IIS to support connectivity solutions from SQL Server Mobile database on a mobile device to database servers running SQL Server 2000 SP3a and above.
Download: Sqlce30setupen.msi
_____________________________
Derek Mitchell
http://www.devbuzz.com
Pocket PC Development
|
Printable Version
SQL Server 2005 Compact Edition tool install guide - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread