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 fluidshell. A session is a server connection with a 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]

      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


  • No labels