Changing the option settings for TDS connections

When SQL Anywhere is serving applications over TDS, it automatically sets relevant database options to values compatible with Adaptive Server Enterprise default behavior. You can change the options for TDS connections at any time.

Prerequisites

There are no prerequisites for this task.

Task

Create a procedure that sets the database options you want.
Set the login_procedure option to the name of the new procedure.

Results

Future connections use the procedure. You can configure the procedure differently for different user IDs.

Example

This procedure example changes only the quoted_identifier option from the default setting.

CREATE PROCEDURE my_startup_procedure()
BEGIN
  IF CONNECTION_PROPERTY('CommProtocol')='TDS' THEN
    SET TEMPORARY OPTION quoted_identifier='Off';
  END IF
END;

Run the following command to set the login_procedure option to the name of the new procedure:

SET OPTION login_procedure= 'DBA.my_startup_procedure';

Changing the option settings for TDS connections

Task

See also