Disconnecting from a Datasource

From DBArtisan
Jump to: navigation, search

Go Up to Connecting to Datasources

When you disconnect from a server, the application immediately breaks the connection between any open ISQL Windows, the servers, and databases. Although your ISQL Windows are still visible, the connections are no longer valid. If you attempt to execute a script, an attempt to reconnect to a registered datasource, if available, is made.

To disconnect from a datasource

  1. In the Datasource Navigator/Explorer, right-click a datasource and select Disconnect. For information on the Navigator/Explorer, see Using the Datasource Navigator/Explorer.
    Note: If necessary, a dialog box opens, asking if you want to commit all pending transactions for that connection or to rollback all before disconnecting. You cannot disconnect if there is an uncommitted transaction.