Export (0) Print
Expand All

Development Tools

SQL Server 2000

Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) supports two development environments: Microsoft Visual Studio® .NET and Microsoft eMbedded Visual Tools. This topic provides general information about the setup requirements for these environments. Each environment requires additional configurations to develop applications for SQL Server CE.

Developing a Visual Studio .NET Application

Note  This feature has been designed to be used in conjunction with a prerelease version of an anticipated successor to Microsoft Visual Studio .NET. Check the documentation accompanying the commercially released version for any updates.

To build a SQL Server CE application using Visual Studio .NET, you must install .NET Compact Framework and Microsoft® Visual Studio® .NET. This product provides all the necessary tools for developing Windows CE-based and Pocket PC-based applications for use with SQL Server CE. For more information, see Installing SQL Server CE with Visual Studio .NET.

To access SQL Server CE-specific objects, you must add a reference to the following Microsoft .NET Compact Framework data providers:

  • System.Data.SqlServerCe (for SQL Server CE)
  • System.Data.SqlClient (for SQL Server version 7.0 or later)

In addition, when you use either of these data providers, you must also add a reference to System.Data.Common. For more information, see .NET Compact Framework Data Providers and the .NET Compact Framework SDK.

You can test your application using the emulator; however, you cannot use Secure Sockets Layer (SSL) encryption when running your applications through the emulator.

Developing an eMbedded Visual Basic Application

To build a SQL Server CE application using eMbedded Visual Basic®, you must install SQL Server CE on a computer running the eMbedded Visual Tools environment. For more information, see Installing SQL Server CE with eMbedded Visual Tools

To build a SQL Server CE application by using Microsoft eMbedded Visual Basic, you must add the reference to Microsoft CE SQL Server Control 2.0. For more information, see Installing SQL Server CE on a Device Using eMbedded Visual Tools.

Debugging an eMbedded Visual Basic Application

When you run or debug your application, eMbedded Visual Basic automatically downloads and registers Ssce20.dll and Ssceca20.dll to the Windows CE-based device. Ssce20.dll implements the SQL Server CE database. SQL Server CE Client Agent (Ssceca20.dll) implements the Replication, RDA, and Engine objects.

Developing an eMbedded Visual C++ Application

For applications that call the Replication and RDA objects, you must include the following files in the eMbedded Visual C++® project:

  • Ca_mergex20.h
  • Ca_mergex20.lib
  • Ole32.lib
  • Oleaut32.lib

You must supply all required parameters for the eMbedded Visual C++ application. If all required parameters are not supplied with a method call, a compilation error occurs because default parameter values for method calls are not supported.

Debugging an eMbedded Visual C++ Application

Before you run or debug the application, you must manually download and register Ssce20.dll and Ssceca20.dll on the Windows CE-based device. Ssce20.dll implements the SQL Server CE database. SQL Server CE Client Agent (Ssceca20.dll) implements the Replication, RDA, and Engine objects.

See Also
Deploying Applications
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft