Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
827
|
| \reconnect | |
| Re-establish an existing connection. | |
| Syntax | |
|
\reconnect [-d DATABASE] [-au] [-su NAME] [-u USER] [-ap] [-sp NAME] [-p PASSWORD] [-auth AUTH] [-ca AS] [-ct TO] |
|
| Description | |
|
The \reconnect command may be used to force a reconnection to the database using a new database, username, or password (if desired). The value provided in the $database variable will be used if no database is specified with the -d option. |
|
| Options | |
|
-d DATABASE sets the database name to switch into upon connect. |
|
|
-au asks for user name. |
|
|
-su NAME reads user name from the secure storage. |
|
|
-u USER sets the user name. |
|
|
-ap asks for password. |
|
|
-sp NAME reads password from the secure storage. |
|
|
-p PASSWORD sets the password. |
|
|
-auth AUTH SQL Server authentication. Possible values: SQLSERVER, WINDOWS, SINGLESIGNON. |
|
|
-ca AS connect to Oracle database as: NORMAL, SYSOPER, SYSDBA, SYSASM. |
|
|
-ct TO connect to Apache Derby: LOCAL, SERVER. |
|
|
-v verbosely reports information about re-established connection. |
|
| Example | |
|
To reconnection to a SQL Server 2000 database with the SQL Server authentication in a linux machine, use the below command. MS SQL SERVER 2000 is the server name found in the Servers Tree \reconnect 'Aqua Servers Tariq/SQL Server/MS SQL SERVER 2000' -d Northwind -u SA -p tariq -auth SQLSERVER |
|
|
To prompt for username and password before reconnecting use the -au and -ap options: \reconnect 'Aqua Servers Tariq/SQL Server/MS SQL SERVER 2000' -d Northwind -au -ap |
|
|
To read the username and password from secure storage under File-->Options-->Secure Storage, use the below command. Create the secure storage objects myuser and mypass, before executing this command \reconnect 'Aqua Servers Tariq/SQL Server/MS SQL SERVER 2000' -d Northwind -su myuser -sp mypass |
|
| See Also | |
|
\connect \disconnect |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017