reconnect (Revision #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 ${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.

-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: does NOT work on SQLite

-s: does NOT work on SQLite

SEE ALSO

connect
disconnect
session

Search Tips

Aqua Data Studio / nhilam

reconnect (Revision #0)

Search Tips

Aqua Data Studio / nhilam

Title

reconnect (Revision #0)