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