This section lists the components and features of SQL Anywhere that are unsupported or have altered functionality on Windows Mobile. Where available, alternatives to unsupported features are listed.
For more information about supported and unsupported components on Windows Mobile, see ![[external link]](gif/external.gif)
http://www.sybase.com/detail?id=1061806.
SQL Anywhere includes several tools for administering databases. These include Sybase Central, Interactive SQL, and utilities. None of these administration tools can be deployed to Windows Mobile. Instead, database administration is performed from a Windows-based computer that is connected to the Windows Mobile device.
For more information, see Using the administration utilities on Windows Mobile.
| Component or feature | Considerations |
|---|---|
| Application profiling | When you create a tracing session for a database running on Windows Mobile, you must configure tracing using the Database Tracing Wizard (you cannot use the Application Profiling Wizard). As well, you must trace data from the Windows Mobile device to a copy of the Windows Mobile database running on a database server on a desktop computer. You cannot automatically create a tracing database from a Windows Mobile device, and you cannot trace to the local database on a Windows Mobile device. See Application profiling. |
| Database mirroring | Unsupported on Windows Mobile. |
| External stored procedures | Unsupported on Windows Mobile. |
| iAnywhere JDBC driver | Unsupported on Windows Mobile. You can use jConnect on Windows Mobile. |
| Java in the database | Unsupported on Windows Mobile. |
| jConnect | The jConnect driver can be enabled when you create a database for Windows Mobile. This can be useful if you want to move the database to a computer that supports Java. However, enabling the jConnect driver adds to the size of the database and, more significantly, adds about 200 KB to the memory requirements for running the database. This additional memory requirement should be considered when running the database in a limited-memory environment like Windows Mobile. See Using jConnect on Windows Mobile. |
| Kerberos authentication | Unsupported on Windows Mobile. |
| LDAP authentication | Unsupported on Windows Mobile. |
| ODBC clients | Windows Mobile does not provide an ODBC driver manager or an ODBC Administrator, so SQL Anywhere uses ODBC data sources stored in files. See Using ODBC data sources on Windows Mobile. |
| Open Client | Unsupported on Windows Mobile. |
| Parallel backups | Unsupported on Windows Mobile. |
| Personal database server (dbeng11) | Only the network database server (dbsrv11) is supported on Windows Mobile. This executable supports local connections and client/server communications across a network. |
| Remote data access (including directory access servers) | Unsupported on Windows Mobile. |
This section describes SQL statements that are not supported on Windows Mobile, and those that have altered or limited functionality.
For a complete list of SQL statements, see SQL statements.
| SQL statement | Considerations |
|---|---|
| BACKUP statement | Only the BACKUP DATABASE DIRECTORY clause is supported on Windows Mobile. |
| CREATE DATABASE statement | The CREATE DATABASE statement can be used to initialize a database on a computer, which can later be copied to a Windows Mobile device. See Creating a Windows Mobile database. |
| CREATE EVENT statement | DiskSpace event types are not supported on Windows Mobile. However, you can use this statement to define the GlobalAutoIncrement event type or the ServerIdle event type. |
| CREATE EXISTING TABLE statement | Unsupported on Windows Mobile. |
| CREATE EXTERNLOGIN statement | Unsupported on Windows Mobile. |
| CREATE FUNCTION statement | The CREATE FUNCTION statement can be used on Windows Mobile to create user-defined SQL functions for use in the database. Note that the EXTERNAL NAME clause is not supported on Windows Mobile. |
| CREATE SERVER statement | Unsupported on Windows Mobile. |
| CREATE TABLE statement | The AT clause of the CREATE TABLE statement for creating proxy tables is not supported on Windows Mobile. |
| DROP DATABASE statement | Unsupported on Windows Mobile. |
| DROP SERVER statement | Unsupported on Windows Mobile. |
| INSTALL JAVA statement | Unsupported on Windows Mobile. |
| REMOVE JAVA statement | Unsupported on Windows Mobile. |
| REORGANIZE TABLE statement | Unsupported on Windows Mobile. |
| RESTORE DATABASE statement | Unsupported on Windows Mobile. |
| START JAVA statement | Unsupported on Windows Mobile |
| STOP JAVA statement | Unsupported on Windows Mobile. |
This section describes those database server options that are not supported or have altered functionality on Windows Mobile.
| Option | Considerations |
|---|---|
| @ data option | Unsupported on Windows Mobile. |
| -? server option | Unsupported on Windows Mobile. |
| -cm server option | Unsupported on Windows Mobile. |
| -cw server option | Unsupported on Windows Mobile. |
| -ec server option |
Strong communication encryption (TLS) is not supported on Windows Mobile. Only the none and simple settings are supported. See -ec server option. |
| -gb server option | Unsupported on Windows Mobile. |
| -ge server option | Unsupported on Windows Mobile. |
| -qi server option | When running, the network database server appears as an icon in the bottom right corner of the Today screen on your Windows Mobile device. This feature cannot be disabled. |
| -s server option | Unsupported on Windows Mobile. |
| -tmf server option | Unsupported on Windows Mobile. |
| -tmt server option | Unsupported on Windows Mobile. |
| -u server option | Unsupported on Windows Mobile. |
| -ua server option | Unsupported on Windows Mobile. |
| -uc server option | Unsupported on Windows Mobile. |
| -ud server option | Unsupported on Windows Mobile. |
| -uf server option | Unsupported on Windows Mobile. |
| -ui server option | Unsupported on Windows Mobile. |
| -ut server option | Unsupported on Windows Mobile. |
| -ux server option | Unsupported on Windows Mobile. |
| -xp server option | Unsupported on Windows Mobile. |
| -ze server option | Unsupported on Windows Mobile. |
The following table lists the Sybase Central wizards that are not supported or have altered functionality on Windows Mobile and provides alternatives where possible.
| Wizard | Considerations |
|---|---|
| Backup Database Wizard |
Archive backups are not supported on Windows Mobile. The Backup Database Wizard is not supported. See Types of backup. As an alternative on Windows Mobile, you can use the Create Backup Images Wizard, which makes a separate backup of the database and transaction log files. See Use the Backup Database Wizard. |
| Change Log File Settings Wizard | Unsupported on Windows Mobile. |
| Create Database Wizard | This wizard provides options for creating database on Windows Mobile, provided Windows Mobile services are installed on the computer running Sybase Central. See Creating a Windows Mobile database. |
| Create Maintenance Plan Wizard |
The following options are not available on Windows Mobile:
|
| Erase Database Wizard | Unsupported on Windows Mobile. |
| Migrate Database Wizard | Unsupported on Windows Mobile. |
| Restore Database Wizard | Unsupported on Windows Mobile. |
| Create Service Wizard | Unsupported on Windows Mobile. |
| Translate Log File Wizard | Unsupported on Windows Mobile. |
| Unload Database Wizard | This wizard cannot map to the Windows Mobile directory where the database files are stored. However, you can unload a Windows Mobile database by copying it to your computer and using the Unload Database Wizard. |
| Upgrade Database Wizard | This wizard is not supported on Windows Mobile. However, you can upgrade a Windows Mobile database by copying it to your computer and using this wizard before copying the database back to your Windows Mobile device. See Upgrading SQL Anywhere. |
SQL Remote is supported on Windows Mobile with the following exceptions:
| Component or feature | Considerations |
|---|---|
| Extraction utility (dbxtract) | Windows Mobile does not support this utility. If necessary, a Windows Mobile database can be copied to a computer so that the Extraction utility can be used. |
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |