Tutorial: Setting up the scenario for the isolation level tutorials

All of the isolation level tutorials use fictional scenarios where a Sales Manager and an Accountant access and change the same information simultaneously. Set up your database for an isolation level tutorial by opening two Interactive SQL windows to act as the Sales Manager and Accountant.

Prérequis

There are no prerequisites for this task.

Task

Start Interactive SQL. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Interactive SQL.
In the Connect window, connect to the SQL Anywhere sample database as the Sales Manager:
1. In the Action dropdown list, click Connect With An ODBC Data Source.
2. Click ODBC Data Source Name and type SQL Anywhere 16 Demo in the field below.
3. Click the Advanced Options tab and type Sales Manager in the ConnectionName field.
4. Click Connect.
Start a second instance of Interactive SQL.
In the Connect window, connect to the SQL Anywhere sample database as the Accountant:
1. In the Action dropdown list, click Connect With An ODBC Data Source.
2. Click ODBC Data Source Name and type SQL Anywhere 16 Demo in the field below.
3. Click the Advanced Options tab and type Accountant in the ConnectionName field.
4. Click Connect.

Résultat

You are connected to the sample database as both the Sales Manager and the Accountant.

Suivant

Perform one of the isolation level tutorials.

Tutorial: Setting up the scenario for the isolation level tutorials

Task

See also