Select a database.
Click File » Disconnect.
Execute a DISCONNECT statement.
Select the database in the left pane, and click the Connections tab in the right pane.
Right-click the user and then click Disconnect.
Connect to the database as a user with DBA authority.
Use the sa_conn_info system procedure to determine the connection ID of the user you want to disconnect.
Execute a DROP CONNECTION statement.
Connect to the database from the SQL Anywhere Console utility.
In the User ID column, right-click the user and click Drop Connection.
You can configure the columns that appear in the SQL Anywhere Console in the Options window, which can be accessed by clicking File » Options.
The following statement shows how to use the DISCONNECT statement to disconnect the current connection, conn1, in Interactive SQL:
DISCONNECT conn1; |
The following statement shows how to use DISCONNECT in embedded SQL:
EXEC SQL DISCONNECT :conn-name |
The following statement drops connection number 4.
DROP CONNECTION 4; |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |