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
|
| connect | |
| Establishes a connection to a database. | |
| Synopsis | |
\connect SERVER [-d DATABASE] [-au] [-su NAME] [-u USER] [-ap] [-sp NAME] [-p PASSWORD] [-auth AUTH] [-ca AS] [-ct TO] \connect [-v] \connect |
|
| Description | |
|
This command is used to establish a connection to a database server. The value provided in the $database variable will be used if no database is specified with the -d option. This command also accepts a single server name as an argument. If invoked with no arguments, this command tries to reconnect to a previously disconnected server. |
|
| Options | |
|
-d DATABASE sets the database name to switch into upon connect |
|
|
-au asks for the user name |
|
|
-su NAME reads user name from the secure storage |
|
|
-u USER sets the user name |
|
|
-ap asks for the password |
|
|
-sp NAME reads the 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 -v
Verbosely reports information about established connection. |
|
| Example | |
|
To open a FluidShell connection 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 \connect 'Aqua Servers Tariq/SQL Server/MS SQL SERVER 2000' -d Northwind -u SA -p tariq -auth SQLSERVER |
|
|
To prompt for username and password before connecting use the -au and -ap options:
\connect '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
\connect 'Aqua Servers Tariq/SQL Server/MS SQL SERVER 2000' -d Northwind -su myuser -sp mypass
|
|
| See Also | |
|
disconnect reconnect |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017