喜愛 0

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]

-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

評論 (0) 附件 (0)

此清單是空的。

搜尋技巧

Aqua Data Studio / nhilam

connect

搜尋技巧

Aqua Data Studio / nhilam

Title

connect