x
This website is using cookies. We use cookies to ensure that we give you the best experience on our website. More info. That's Fine
HPC:Factor Logo 
 

SQL Server CE 1.1

Download Summary:

Support the Site
Become a HPC:Factor Plus Subscriber Member button
Support us on Patreon button
Support HPC:Factor in continuing to offer support and downloads to the community! Make a donation button.

Microsoft has updated Microsoft SQL Server 2000 Windows® CE Edition (SQL Server CE) version 1.1 Service Pack 1 (SP1) to include support for Windows CE .NET devices.

You are not currently logged-in. To download you must be logged-in and be a subscriber or have met our community quality and reputation requirements as a free user - Find out more · Subscribe
Version:
SP1
Developer:
Microsoft Corporation
Download Size:
885 KB - 269.24 MB
Release Date:
18/03/2002
Language:
Chinese (Taiwan),English,French (France),German (Germany),Italian (Italy),Japanese,Korean,Spanish (Traditional Sort)
Popularity:
2699
Number of Downloads:
1
Added By:
C:Amie on 19/05/2019 11:38:53 AM

Overview:

Important: Microsoft has updated Microsoft SQL Server 2000 Windows® CE Edition (SQL Server CE) version 1.1 Service Pack 1 (SP1) to include support for Windows CE .NET devices. SQL Server CE 1.0 users must upgrade to SQL Server CE 1.1 before applying this service pack. Read SQL Server CE 1.1 SP1 Readme.txt Addition on the PSS site for instructions on how to determine which version of SQL Server CE you have installed.
New in Service Pack 1

SQL Server CE 1.1 SP1 provides support for the new Pocket PC 2002 Software Development Kit (SDK), the Handheld PC 2000 SDK, and Windows CE .NET devices. Extensions of enterprise applications are now integrated and recognized as part of the SQL Server CE setup, so mobile application developers can build on these new Windows CE operating environments.

You can use SQL Server CE 1.1 with SP1 to take advantage of larger storage technologies for mobile devices. To minimize main RAM usage, SQL Server CE 1.1 with SP1 enables you to locate the temporary databases used to store data during processing, queries, replication, and so forth on alternative storage devices, such as removable storage (CompactFlash, Microdrive, and so on). This way your system won't run out of memory when it creates temporary database files during complex processing. Main memory is now conserved for the main database file and application.


This article provides information about the following issues, which were not included in the Readmesp1.txt file for SQL Server 2000 Windows CE Edition (SQL Server CE) Service Pack 1 (SP1):

A potential issue for Handheld PC and Handheld PC 2000 Windows CE-based devices.

A potential issue during desktop installation.

Support for Microsoft Windows CE .NET.

Different SQL Server CE files used for Windows CE .NET and Pocket PC 2002 emulators.

How to determine which version of SQL Server CE 1.1 is currently installed.

MORE INFORMATION
Issues

Potential Issue for Handheld PC and Handheld PC 2000 Windows CE-based Devices

If you are pushing an application to a Handheld PC device by using Microsoft eMbedded Visual Tools, you may receive the following error message on the target device:
Failed to load resource DLL MSDAEREN.DLL.
You can ignore this error message. Click OK on the target device, and the file transfer process from the desktop computer will continue. This problem can occur on Handheld PC devices that have been reset since the last time a SQL Server CE application was started on the Handheld PC device. The warning message does not occur on Handheld PC devices with custom CAB file installations.

NOTE: This issue is not present in the SP1 Update release.

Potential Issue During Desktop Installation

When installing the SQL Server CE SP1 Update to your desktop computer, you may receive the following error message:
An incompatible previous version of SQL Server CE has been detected and must be removed from your machine before this install can continue. Do you want us to do this for you? Click on "No" to stop the setup now, or click on "Yes" to remove the previous version and continue with setup.
The error message may occur even though you have version 1.1 previously installed. Click Yes and the installation process for the desktop computer continues.

Support for Windows CE .NET

Downloads of the SQL Server 2000 Windows CE version 1.1 SP1 Update support devices that are running the Windows CE .NET operating system.

Note the following:

Windows CE .NET must be installed on your desktop system prior to SQL Server CE for proper integration.

SQL Server CE currently does not support the following Windows CE .NET platforms:

MIPS II 5274
MIPS IV
MIPS IV_FP
MIPS16
ARM V4I
ARM V4T
To use SQL Server CE encryption features, a platform must include the Microsoft Enhanced Cryptographic Provider (Rsaenh.dll).

When installing SQL Server CE on your desktop development computer, you may receive the following error message if you had previously installed Platform Builder 3.0 on that computer:
The installation was interrupted before SQL Server CE could be installed...
If the error message occurs, you must manually delete the following key in the desktop registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Platform Builder\3.0

Different SQL Server CE Files Used for Windows CE .NET and Pocket PC 2002 Emulators

The correct files to copy for emulator support for Window CE .NET and Pocket PC 2002 are different from those for other platforms. If you manually install SQL Server CE into the emulator for Windows CE .NET or Pocket PC 2002, copy the files from the C:\Program Files\Microsoft SQL Server CE\Device\x86\I486 folder instead of the C:\Program Files\Microsoft SQL Server CE\Device\x86\Emulation folder. The files in x86\Emulator folder are intended only for the Pocket PC, Handheld PC Pro, and Palm Size PC emulators. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
317851 PRB: SQL Server CE x86 Emulation Files Do Not Work on Pocket PC 2002 Emulator
How to Determine Which Version of SQL Server CE 1.1 Is Currently Installed

SQL Server CE SP1 downloads were updated on 3/18/2002. To determine the version of SQL Server CE 1.1 that is currently installed on the computer, check the SSCE10.dll file located on the development computer used to create SQL Server CE applications.

On the development computer, search for SSCE10.dll. SSCE10.dll is usually located in the \Program Files\Microsoft SQL Server CE\Device\ folder, under the processor type you are deploying.
Right-click the SSCE10.dll file, and then click Properties.
On the Version tab, click File Version. The file versions available include:
1.1.2504.11 - SQL Server CE v1.1
1.1.3606.01 - SQL Server CE v1.1 SP1
1.1.3606.03 - SQL Server CE v1.1 SP1 update

System Requirements:

Hard Disk SQL Server CE on an IIS system
120 megabytes (MB) of available hard disk space.

SQL Server CE on a development system
30 MB of available hard disk space.

SQL Server CE on a Windows CE–based device
1–3 MB of available storage space, depending on processor type, operating system version, and components installed.
Operating system SQL Server CE on an IIS system
Microsoft Windows® NT® operating system version 4.0 with Service Pack 5 or later, or the Windows 2000 operating system.

SQL Server CE on a development system
Microsoft Windows 98, Windows Millennium Edition, Windows NT 4.0 with Service Pack 5 or later, Windows 2000, or Windows XP.

Note: Windows 98 does not support Windows CE desktop emulation.

SQL Server CE on a Windows CE–based device
Windows CE operating system version 2.11 or later for a Handheld PC Pro (H/PC Pro) or Palm-size PC (P/PC); Windows CE 3.0 or later for a Pocket PC 2002, Pocket PC and Handheld PC 2000.
Other Devices SQL Server CE on an IIS system
Microsoft Internet Explorer version 5.0 or later.

SQL Server CE on a development system
Internet Explorer 5.0 or later to access HTML Help.

Installation Instructions:

Installing SQL Server CE

A SQL Server 2000 Windows® CE Edition (SQL Server CE) installation includes up to four systems: a system running SQL Server¹, a system running Microsoft Internet Information Services (IIS)², a development system³, and a Windows CE–based device4. You can use the same computer as the SQL Server system, the IIS system, and the development system.

A set of important software updates are included in this service pack. You should install SQL Server CE 1.1 SP1 to ensure that you have the latest set of program updates.

Download:

You are not currently logged-in. To download you must be logged-in and be a subscriber or have met our community quality and reputation requirements as a free user - Find out more · Subscribe

Donate:

Support the Site
Become a HPC:Factor Plus Subscriber Member button
Support us on Patreon button
Support HPC:Factor in continuing to offer support and downloads to the community! Make a donation button.
HPC:Factor believes that the Internet is a better place without the constant displaying of adverts on community website resources and as such does not carry 'ad-words', banners, pop-up's or any other form of paid advertising.

Please help to pay for the download that you are getting from us today and help to support our desire to run the site without paid subscriptions or advertising by making a donation to the site. It doesn't matter how much or little you donate, but by donating you will help to ensure that we can continue to offer some of the Internet's most popular, rarest and unusual downloads for Windows CE devices for now and for the future.