UltraLite behavior changes and deprecated features

Note

As with all forward-looking statements, the lists of deprecated features are not guaranteed to be complete and are subject to change.

Following is a list of deprecated features and behavior changes to UltraLite introduced in version 12.0.0. For information about supported platforms and versions, see [external link] http://www.sybase.com/detail?id=1061806.

Deprecated features

ulcreate utility no longer supported The ulcreate utility is no longer available. All of the functionality is now handled by ulinit. See UltraLite Initialize Database utility (ulinit).
SQL passthrough no longer supported SQL passthrough, originally released with UltraLite 11, is no longer supported. This functionality is now handled by the Central administration of remote databases.
Option to ALTER SYNCHRONIZATION PROFILE using the OR REPLACE clause is no longer supported The OR REPLACE clause has been removed from the ALTER SYNCHRONIZATION PROFILE statement.
UltraLite ODBC API no longer supported The UltraLite ODBC API is no longer supported. Use the UltraLite C/C++ API in its place. See UltraLite - C and C++ Programming.

Deprecated platforms

UltraLite for M-Business Anywhere no longer supported UltraLite support for M-Business Anywhere is deprecated for UltraLite 12.
Palm operating system no longer supported The Palm operating system is not supported by UltraLite 12.

Removed, deprecated, and modified APIs

Replaced UltraLite C/C++ API The UltraLite C/C++ API defined in the uliface.h header file has been replaced by a new version that is defined in the ulcpp.h header file. The previous version of the API is still available. For documentation on the deprecated UltraLite C/C++ API, see http://dcx.sybase.com/1101en/ulc_en11/c-common-apiref.html.
You can use the old implementation of the UltraLite C/C++ API by adding the %SQLANY11%\SDK\C\ulcpp11.cpp file to your UltraLite application project, where SQLANY11 is an environment variable that points to your SQL Anywhere installation directory.
Modified UltraLite C/C++ API objects The following objects have been modified since the last release and apply to the new UltraLite C/C++ API:
- SQL Passthrough is no longer supported by the API. The following objects have been removed:
  - ul_sql_passthrough_state
  - ul_sql_passthrough_status
  - ul_sql_passthrough_observer_fn
Modified UltraLite C/C++ common API objects The following objects have been modified since the last release:
- The MLFileTransfer function has been renamed to MLFileDownload. See MLFileDownload method [UltraLite Embedded SQL].
- The force_transfer field of ml_file_transfer_info structure has been removed.
- The enable_resume field of ml_file_transfer_info now defaults to true instead of false. See MLFileDownload method [UltraLite Embedded SQL].
- MLFileDownload supports the new remote_key field of ml_file_transfer_info which is passed to MobiLink server scripts to allow greater control of file transfers. See MLFileDownload method [UltraLite Embedded SQL].
embedded Visual C++ not supported as of UltraLite 11.0 Support for Visual Studio 2003 ended with UltraLite 11.0. Support for embedded Visual C++ was therefore moved into Visual Studio 2005.
Modified Embedded SQL API objects The following objects have been modified since the last release:
- SQL Passthrough is no longer supported by the API. The following objects have been removed:
  - ULGetSQLPassthroughScriptCount
  - ULExecuteNextSQLPassthroughScript
  - ULExecuteSQLPassthroughScripts
  - ULSetSQLPassthroughCallback
Modified UltraLite for M-Business Anywhere API objects The following objects have been modified since the last release:
- The GetSQLPassthroughScriptCount, ExecuteNextSQLPassthroughScript, and ExecuteSQLPassthroughScripts methods in the Connection class have been removed.
- The syntax of the CreateDatabase method in the DatabaseManager class has changed.
Modified UltraLite.NET API objects The following objects have been modified since the last release:
- The DatabaseManager property under the ULConnection class has been removed and is no longer required. ULDatabaseManager is no longer a singleton class; the methods are now static. See ULDatabaseManager class [UltraLite.NET].
- The DatabaseOnCE property in the ULConnectionParms class has been renamed to DatabaseOnDevice. See ULConnectionParms.DatabaseOnDevice property [UltraLite.NET].
- The GetOptimalIndex method in the ULTableSchema class now returns the name of the optimal index. See ULTableSchema.GetOptimalIndex method [UltraLite.NET].
- The CountUploadRows(String, UInt32) method in the ULConnection class has been removed. Use CountUploadRows(String, Int64) instead. See ULConnection.CountUploadRows method [UltraLite.NET].
- SQL Passthrough is no longer supported by the API. The following objects have been removed:
  - ULConnection.GetSQLPassthroughScriptCount
  - ULConnection.ExecuteNextSQLPassthroughScript
  - ULConnection.ExecuteSQLPassthroughScripts
  - ULSqlPassthroughProgressListener
  - ULSqlProgressData
  - ULSqlProgressState
- The ULPublicationSchema class and its methods have been removed, along with the GetPublicationSchema method in the ULDatabaseSchema class. The SYNC_ALL_DB and SYNC_ALL_PUBS fields have moved to the ULConnection class. See ULConnection.SYNC_ALL_DB field [UltraLite.NET] and ULConnection.SYNC_ALL_PUBS field [UltraLite.NET].

Miscellaneous

User publication limit increase The maximum number of user publications has increased to 63.
Default encoding for UltraLite databases is now UTF-8 encoded UltraLite databases are now UTF-8 encoded by default. See UltraLite utf8_encoding creation parameter.

Discuss this page in DocCommentXchange.