New Features and Upgrading Guide
   CHAPTER 2. New Features in Adaptive Server Anywhere 6.0.1     

Adaptive Server Anywhere for Windows CE

The Microsoft Windows CE operating system developed for handheld computing devices and embedded devices custom-built to carry out a specific task.

Starting with Version 6.0.1, Adaptive Server Anywhere is available for Windows CE. Versions 2.0 and up of the CE operating system are supported.

The Windows CE version of Adaptive Server Anywhere has the following characteristics:

• Full-featured database     All SQL features in other versions of Adaptive Server Anywhere are available in the Windows CE version, including transaction processing, referential integrity actions, procedures and triggers, and so on.

  The Java features and the remote data access features are not available in Windows CE.

• Administer from your desktop     When running Windows CE on a device that can be attached to a network or directly to a PC, you can administer your Windows CE database from a Sybase Central running on the PC.

• ODBC and Embedded SQL applications     You can use either of these interfaces to develop client applications.

• SQL Remote replication     The SQL Remote file link is implemented to be compatible with Windows CE ActiveSync synchronization.

  Desktop management of Windows CE databases

Instead of the personal database server, the network database server (dbsrv6.exe) is supplied with Windows CE. The network server supports communications over a TCP/IP network link.

The usual client/server arrangement has the database server running on a machine with more power and resources than the client applications. Clearly, this is not the case with Windows CE; instead, the less powerful machine is running the database server.

The advantage to supplying a network server on Windows CE is that you can run database applications on your desktop computer to carry out tasks on your Windows CE database. For example:

• You can use Sybase Central on your desktop PC to manage your database

• You can use Interactive SQL on your desktop to load and unload data, and carry out queries.

• You can use InfoMaker to produce reports.

The Windows CE database server does not start the TCP/IP network link unless it is explicitly requested:

dbsrv6 -x tcpip ...

  Creating Windows CE databases

If you have Windows CE services installed on your Windows 95 or Windows NT desktop, you get an option to create a Windows CE database when you create a database from Sybase Central (Windows Edition). Sybase Central enforces the requirements for Windows CE databases, and optionally copies the resulting database file to your Windows CE machine.

  SQL Remote and Windows CE

If you have Windows CE services installed on your Windows 95 or Windows NT desktop, you get an option to create a Windows CE database when you extract a remote database from Sybase Central (Windows Edition). Sybase Central enforces the requirements for Windows CE databases, and optionally copies the resulting database file to your Windows CE machine.

From within the Sybase Central (Windows Edition) Utilities folder, if you have Windows CE services installed, you have an option to set up SQL Remote for ActiveSync synchronization. This sets your folder for FILE message link messages to be the ActiveSync folder. When you dock your Windows CE machine to your desktop machine, ActiveSync keeps the files in your desktop machine's ActiveSync folder synchronized with those in the Windows CE ActiveSynce folder.

  Windows CE database features

The Windows CE version of the database software contains all the features found on other operating systems except for a few features that are not appropriate for Windows CE. The excluded features include the following:

• Java in the Database

• External procedures and functions

• Only the network database server is supplied.

The following SQL statements are not supported on Windows CE:

• ALTER DATABASE

• ALTER SERVER

• ALTER WRITEFILE

• CREATE COMPRESSED DATABASE

• CREATE DATABASE

• CREATE EXPANDED DATABASE

• CREATE EXTERNLOGIN

• CREATE EXISTING TABLE and CREATE TABLE using the AT clause.

• CREATE SERVER

• CREATE WRITEFILE

• DROP DATABASE

• DROP SERVER

• INSTALL JAVA

• REMOVE JAVA

• START JAVA

• STOP JAVA

  Using ODBC with Windows CE

There is no ODBC driver manager for Windows CE. This requires changes to the use of data sources compared to other Windows operating systems.

     For information on how to use ODBC data sources with Windows CE, see Using ODBC data sources on Windows CE.