connect (Revision #5)

\connect SERVER [-d DATABASE] [-au] [-su NAME] [-u USER] [-ap] [-sp NAME] [-p PASSWORD] [-auth AUTH] [-ca AS] [-ct TO]
\connect [-v]
\connect

Establish fluidshell's connection to SERVER which specifies the server name in a folder provided by the ${CONNECTIONS} shell variable. 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.

-ct TO
connect to Apache Derby: LOCAL, SERVER.

-v

Verbosely reports information about established connection.
 

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