reconnect (Révision #0)

NAME

reconnect - reestablish a database connection

SYNOPSIS

reconnect [OPTION...]

DESCRIPTION

Disconnect and reconnect to the database. You may provide new connection information to use on reconnect.

If the connection is from a Query Analyzer window, this command will attach the current connection from the Query Analyzer window to the FluidShell session.

If the ${DATABASE} shell variable is defined, it overwrites previously used database name. If -d option is specified, it overwrites both ${DATABASE} shell variable and previously used database name.

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.

-d DATABASE
Set the database name to switch into upon connect.

-p PASSWORD
Set the password.

-s SCHEMA
sets the schema to be used

-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.

-v
Verbosely report information about re-established connection.

EXAMPLES

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

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.

-s: This option will be ignored if it is not supported by the connected server, e.g. SQLite.

SEE ALSO

connect
disconnect
session

Astuces de Recherche

Aqua Data Studio / nhilam

reconnect (Révision #0)

Astuces de Recherche

Aqua Data Studio / nhilam

Title

reconnect (Révision #0)