× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Like  

connect

NAME
connect - establish a database connection
 
SYNOPSIS
connect [-v]
connect [OPTION...] SERVER

 
DESCRIPTION
Establish fluidshell's connection to SERVER which specifies the server name in a folder provided by the ${CONNECTIONS} shell variable. If -qa option is specified, then it will attach the connection from the specified Query Analyzer window to the FluidShell session. If no arguments are passed or only -v option is specified then it will attempt to re-establish a connection to the previous connection.
 
If both ${SERVERNAME} and ${DATABASE} shell variables are defined, and the ${SERVERNAME} shell variable matches SERVER, then the ${DATABASE} shell variable overwrites the database property defined in the file specified by SERVER. If -d option is specified, it overwrites both ${DATABASE} shell variable and SERVER's database property.
 
An opened connection is managed as a session by fluid shell. A session is a server connection with an unique identifier assigned. Session identifier can be specified by -k option, default to 'default'. Multiple sessions can be created and tracked in a fluid shell, please see \session manual page for more information.
 
OPTIONS
-ap
Ask for the password.
 
-au
Ask for the user name
 
-auth {SQLSERVER | WINDOWS | SINGLESIGNON}
SQL Server authentication.
 
-ca {NORMAL | SYSOPER | SYSDBA | SYSASM}
Connect to Oracle as.
 
-ct {LOCAL | SERVER}
Connect to Apache Derby.
 
-sp NAME
reads the password from the secure storage
 
-s SCHEMA
sets the schema to be used
 
-d DATABASE
Set the database name to switch into upon connect.
 
-k SESSION_ID
Set the session identifier for the newly opened connection.
 
-p PASSWORD
Set the password.
 
-sp SECURE_STORAGE_NAME
Read the password from the secure storage.
 
-su SECURE_STORAGE_NAME
Read the user name from the secure storage.
 
-u USER
Set the user name.
 
-qa QA_WINDOW_TITLE
Use the connection from the Query Analyzer window.
 
-v
Verbosely report information about established connection.
 
EXAMPLES
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

 
NOTES
USER option order of acceptance [-u, -au, -su], [-p, -ap, -sp]
 
USER option order of acceptance [-u, -au, -su], [-p, -ap, -sp]
 
-auth: SQL Server Only
 
-ca: Oracle Only
 
-ct: Apache Derby Only
 
-d: This option will be ignored if it is not supported by the connected server, e.g. SQLite.
 
-qa: When this option is specified, the -k option specifies the session identifier for the connection and all other options are ignored.
 
-s: This option will be ignored if it is not supported by the connected server, e.g. SQLite.
 
 
 
SEE ALSO
disconnect
reconnect
session
 

 

Last updated by NielsGron on Jul 28, 2015 8:59 PM
This list is empty.

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017