What's New in SQL Anywhere Studio
  What's New in Version 7.0.1
    New features in version 7.0.1

Adaptive Server Anywhere new features

This section introduces the new features in Adaptive Server Anywhere version 7.0.1. It provides an exhaustive listing of major and minor new features, with cross references to locations where each feature is discussed in detail.

• New Service Creation utility    Running a database server as a service under NT allows databases to keep running without tying up the machine on which they are running. Previously, you added services using the Create a New Service wizard from Sybase Central. In Version 7 of Adaptive Server Anywhere, you can now also manage ASA services on Windows NT using a the Service Creation [dbsvc] utility. A variety of options allow you to add or delete a service, list all ASA services, or display the details of a particular service. This feature is particularly useful for embedding the creation of a service in installations.

  For more information about the Service Creation utility, see The Service Creation utility.

• Windows CE 3.0 support    In addition to Windows CE 2.11, Adaptive Server Anywhere now supports Windows CE 3.0 on the following processors:

  • MIPS

  • Hitachi SH3.

  • ARM.

  Support for Windows CE 2.11 is provided on a wider range of platforms. For more information, see Windows and NetWare operating systems.

  With support for Windows CE 3.0, the OLE DB driver on CE works without installing any additional software.

• Embedded SQL enhancements    A new function, db_locate_servers, provides a programmatic way of locating Adaptive Server Anywhere database servers listening on TCP/IP.

  For more information, see db_locate_servers function.

  A new callback function, DB_CALLBACK_CONN_DROPPED, provides a way of adding logic when the database server is about to drop a connection.

  For more information, see db_register_a_callback function.

• Connection-level Debug and Logfile connection parameters    The DBG and LOG client-side connection parameters are now connection-specific, so you can configure debug information separately for different connections, even from the same application.

  For more information, see Logfile connection parameter [LOG].

• New database property    The LTMGeneration property has been added for users of the Replication Agent, or LTM. This property is primarily for use in technical support cases.

  For more information, see Database-level properties.

• New deployment feature    Users of InstallShield Professional 5.5 and up can use the new SQL Anywhere Studio InstallShield Template Projects to deploy their own application. This feature allows you to quickly build your application's installation using the entire template project, or just the parts that apply to your install.

  For more information, see Using InstallShield for deployment.

• New backup statement feature    When using the Backup statement, you can specify an empty string as a directory to rename or truncate the log without copying it first. This is particularly useful in a replication environment where space is a concern. You can use this feature with an event handler on transaction log size to rename the log when it reaches a given size, and with the DELETE_OLD_LOGS option to delete the log when it is no longer needed.

  For more information, see the BACKUP statement.